Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Testing all procs before upgrading to Compatibility Level 90 Expand / Collapse
Author
Message
Posted Monday, February 4, 2008 9:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:35 AM
Points: 74, Visits: 549
Comments posted to this topic are about the item Testing all procs before upgrading to Compatibility Level 90
Post #451202
Posted Thursday, March 27, 2008 10:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:58 AM
Points: 13,872, Visits: 9,600
Clever. I like it. This'll come in useful to me on the project I'm doing next week. Thanks.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #475592
Posted Tuesday, September 1, 2009 11:36 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
Thx - this will prove useful in the new environment i just inherited.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #780923
Posted Friday, December 24, 2010 11:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 25, 2014 1:01 PM
Points: 122, Visits: 205
I think I am missing something here... The database is compatibility level 80 and the script tries to create a proc in that database and expects it to trap the ones that error out because they aren't compatible with level 90. If compatibility level applies to the whole database then how can it error out on a proc that isn't being created on a level 90 database? I've got a stored procedure in a level 80 database that I believe should be incompatible in level 90 and above because no WITH keyword is with the locking hint, something like...

Create procedure dbo.test_with
as
select col1, col2, col5 from dbo.table nolock
go

When I run the script it doesn't report the procedure as a problem.

Either I don't understand something I need to do with the script or I don't understand the compatibility differences here
http://msdn.microsoft.com/en-us/library/bb510680.aspx

Can anyone enlighten me about this?

Thanks.
Post #1039151
Posted Friday, December 24, 2010 12:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 25, 2014 1:01 PM
Points: 122, Visits: 205
Since my last posting I've found an article that says that some of the table hints including nolock are exceptions to the 'WITH' keyword rule.

Thanks.
Post #1039161
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse