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 ««12

Compatibility issue and CROSS APPLY Expand / Collapse
Author
Message
Posted Saturday, August 8, 2009 4:46 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:37 AM
Points: 538, Visits: 774
While the problem is a simple one, I am sure every one of us has a story when we spent hours if not days on something completely trivial only to say at the end: Duh! Thank you for sharing your experience, I am sure you saved some folks a lot of frustration.


Post #767452
Posted Monday, August 10, 2009 4:36 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711
Changing the compatibility level without checking to see if something else broke could be a recipe for disaster; not really sure if this is a viable solution, I think the answer to this is a little misleading.

Compatibiltiy level can effect many other things within the application, so I would proceed with caution!
Post #767732
Posted Monday, August 10, 2009 11:45 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Sunday, October 5, 2014 1:48 AM
Points: 143, Visits: 551
Yes you are right. But we can do one thing change the compatibility level to 90 and then perform the operation and again change the compatibility to 80..

This problem i have faced as we have migrated from SQL Server 2000 to 2005 but the compatibility level remains the same, so it wont make any harm as such


--Divya
Post #768375
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse