May 30, 2011 at 1:52 am
Hi
we migrated our SQL Server Database SQL Server 2000 EE to SQL Server 2005 SP4 EE 64 bit in our Concern.But still our user databases Compatibility Level is 80 in this database contain more than 2500 user tables and 1500 store procedures and views.Now we plan to change the Compatibility Level to 90.what are the changes we will do in our user database. kindly suggest me for do this work successfully.
May 30, 2011 at 3:10 am
http://msdn.microsoft.com/en-us/library/ms143532(v=SQL.90).aspx
check this link and apply in your scenerio
your application built on ? which one using this database
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 30, 2011 at 5:14 am
raguyazhin (5/30/2011)
Hiwe migrated our SQL Server Database SQL Server 2000 EE to SQL Server 2005 SP4 EE 64 bit in our Concern.But still our user databases Compatibility Level is 80 in this database contain more than 2500 user tables and 1500 store procedures and views.Now we plan to change the Compatibility Level to 90.what are the changes we will do in our user database. kindly suggest me for do this work successfully.
if you have any old ANSI queries they will fail to execute in 90 compatability mode. On the plus side support for options like TRY.. CATCH are available in 90 compatability mode
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply