newsgrps
newsgrps at dalyn.co.nz
Tue Jun 21 17:42:16 CDT 2011
Thanks. At 22/06/2011, Francisco Tapia wrote: >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> > > > > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com