Try Catch Block

Question

Post reply

Try Catch Block

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Run the following query on the server and post back the results:

select @@version

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

Well - you can change the compatibility level using sp_dbcmptlevel

http://msdn2.microsoft.com/en-us/library/ms178653.aspx

However - some behaviors change from one compat level to another, AND - you can't "go back". This is not something you want to just do without testing it out.... At very least - make a copy and reattach under a new name, and THEN change the compat level on the new version. That way you can double-check everything still works.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

madan.25 Old Hand Points: 397 More actions · Answer 3

I 'M USING SQL SERVER 2005 MANAGEMENT STUDIO BUT I GOT THE ABOVE RESULT FROM SELECT @@VERSION

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Okay, having several SQL Server 2000 systems here, I looked at the properties of a database on one of the SQL Server 2000 servers, and the only compatibilty modes availabe in SSMS for those databases is SQL Server 7 (70) and SQL Server 2000 (80). The server you are trying to create this procedure on is not SQL Server 2005 even though you are using SSMS.

😎

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 5

The @@version reports what the SERVER is...SSMS is just the client, which can to some degree be used against 2000 and 2005 servers (small issues against 2000).

That unfortunately doesn't change what the server can do, and TRY/CATCH is out.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

madan.25 Old Hand Points: 397 More actions · Answer 6

OH YAH...I UNDERSTOOD.

THANKS A LOT GUYS FOR YOUR TIME