March 29, 2007 at 3:54 pm
If you change the compatiablity modes from 80 to 90 in SQL Server 2005 will it force a restart?
March 29, 2007 at 4:39 pm
No.
Greg
Greg
March 29, 2007 at 9:46 pm
It may recompile the all the procedures the database in which you changed compatability....
MohammedU
Microsoft SQL Server MVP
March 30, 2007 at 3:21 am
You are updating the database Schema(s), so you will need a schema update lock. This is another way of saying changing compatibility mode on a database can only be done when no other users are active on that database.
Also, remember you can change from 8.0 to 9.0, but you cannot change from 9.0 to 8.0.
There is no requirement to restart SQL Server just because you change compatibility mode on a database. Nothing is gained by a restart that does not happen without a restart in this situation.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 30, 2007 at 6:07 am
Also, remember you can change from 8.0 to 9.0, but you cannot change from 9.0 to 8.0.
Really... Our first SQL 2005 install I created three new dbs as V 9.0, the install of the app created the tables and then later it was determined that the software vendor certified SQL 2005 but ONLY if the dbs were in 8.0 compatibility level so I switched them to 8.0. It all seems to work ok.....
Hum....
March 30, 2007 at 6:40 am
"Also, remember you can change from 8.0 to 9.0, but you cannot change from 9.0 to 8.0." add "if you have enabled any features new to SQL 2005" .... d'oh!
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply