May 14, 2008 at 7:45 am
I inherited two databases that are at compatibility level 65. These databases are on SQL 2000 server. What is the best way to move these databases to level 80. These are our document file server databases so they are both very large and important databases.
May 14, 2008 at 10:15 am
sp_dbcmptlevel 80
May 14, 2008 at 7:29 pm
Are there any implications if i change the compatibility level from 65 to 80? what if i use Enterprise Manager? in DB Properties?
"-=Still Learning=-"
Lester Policarpio
May 20, 2008 at 3:43 pm
As far as I know, there is no issue in changing compatibility level on SQL Server side. What you need to do is to check whether or not your application interface has any issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply