[dba-SQLServer] Updating Database Compatibility Level

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




More information about the dba-SQLServer mailing list