Compatibility level 70 means you are trying to SQL Server 7.0 mode? Is that what you really want to do? You obviously will not be able to use any SQL 2005 features.
Look for sp_dbcmptlevel in BOL and check out all the info.
|||Yes we want the database to be in 7.0 mode. I understand the options. What I want to know is... is there a performance hit by using different compatiblity modes? Since SQL 2005 'performs' better than SQL 7 or SQL 2000, will we see any of that performance related to queries etc, or will the added overhead of the compatibility negate the performance improvements.
Also, what performance related issues are there to consider when using different modes, if any?
Thanks,
Raymond Laubert
MCDBA, MCITP:Administrator, MCT
No comments:
Post a Comment