Cannot Upgrade Stored Procedures to SQL 2000

I have a SQL 6.5 that containts the statement "RAISERROR
(@.@.ERROR,16,1)" in a lot of stored procedures. When I try
creating those procedures on SQL 2000 I get a syntax error
pointing to the statement. Does someone knows any database
option or something like that that I could change to avoid
that error?
Check out sp_dbcmptlevel in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Reinaldo Sture" <reinaldo.sture@.barcap.com> wrote in message
news:39b201c4aa52$de22f690$a401280a@.phx.gbl...
I have a SQL 6.5 that containts the statement "RAISERROR
(@.@.ERROR,16,1)" in a lot of stored procedures. When I try
creating those procedures on SQL 2000 I get a syntax error
pointing to the statement. Does someone knows any database
option or something like that that I could change to avoid
that error?
|||Compatibility model is 8.0, but back it is my last option... Are there
something else that I can do?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!