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 |
|
shankar_ss
Starting Member
4 Posts |
 Posted - 2010-03-25 : 00:33:38
|
| Hi,Am using SQL Server 2008. When am creating db, the default Compatibility level is set to SQL Server 2005 (90). We can change the compatibility level manually to SQL Server 2008 (100)in each DB.But I would like know is there any option in SQL Server 2008 to set SQL Server 2008 (100) by default whenever a database is created?Kindly help me on this.Thanks,Shankar |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-03-25 : 00:43:02
|
| The model database is used as the template for all databases created on an instance of SQL ServerChange the Compatibility level of model database.Regards,Bohra |
 |
|
|
shankar_ss
Starting Member
4 Posts |
Posted - 2010-03-25 : 09:23:37
|
| Thank you So much Bohra.. It worked. Thanks a lot.Regards,Shankar |
|
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-03-25 : 12:13:48
|
Welcome  |
|
|
|
|
|
|
Compatibility Level