Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
micahchu
Starting Member
1 Post |
 Posted - 2010-12-09 : 13:53:09
|
| Are there any variables I can look at like DB size etc to estimate how long I can expect this query to execute? I am changing from 80 to 90, and it has now been executing for almost 20 minutesALTER DATABASE mydb SET SINGLE_USEREXEC sp_dbcmptlevel mydb, 90GOALTER DATABASE mydb SET MULTI_USER |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
InfraDBA
Starting Member
38 Posts |
Posted - 2010-12-20 : 17:41:07
|
| I guess you are inside mydb and executing the command... |
 |
|
|
|
|
|
change of compatibility level