Francisco Tapia
fhtapia at gmail.com
Tue Jun 21 16:31:51 CDT 2011
yes, just changing the compatibility level will change what is needed for the database and allows you access to all the newer sql server 2008 features. the advantage is that you are more compatible with the current engine. As Microsoft moves forward you will have features supported in previous version of sql server deprecated or behave oddly, to help avoid odd behavior you'd normally update to the current compatibility level. Other than syntax and the newer sql 2008 features I don't know what else would be the pressing issue unless the company runs scripts specifically targeted at a specific database version. -Francisco http://bit.ly/sqlthis | Tsql and More... http://db.tt/JeXURAx | Drop Box, Storage in the Cloud (free) On Tue, Jun 21, 2011 at 1:33 PM, newsgrps <newsgrps at dalyn.co.nz> wrote: > Team, > > I have an SQL 2005 database that has been attached to SQL2008. Everything > runs fine. > > An IT audit company has made the following recommendation: > > "A review of the databases has highlighted that the database "StockData4" > is SQL 90 which is the SQL 2005 compatibility level (SQL 2008 compatibility > level should be 100). It is recommended that an upgrade of the database > StockData4 with the correct compatibility level be undertaken." > > From what I have read this just involves changing the databases > compatibility level setting. Apart from being able to use features > introduced in SQL2008, is there any other advantage to the change? Are > there any disadvantages? Is there anything else that might be affected by > the change that I should know now and fix? > > > ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com> > >