Compatibility issue and CROSS APPLY

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Divya Agrawal » Compatibility issue and CROSS APPLY

13 posts, Page 2 of 2

««1 2

Compatibility issue and CROSS APPLY

Rate Topic

Display Mode

Topic Options

Author

Message

mishaluba

Posted Saturday, August 08, 2009 4:46 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525, Visits: 617

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

SuperDBA-207096

Posted Monday, August 10, 2009 4:36 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 02, 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

Divya Agrawal

Posted Monday, August 10, 2009 11:45 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:41 AM
Points: 140, Visits: 474

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 »

13 posts, Page 2 of 2

««1 2

Permissions