what is cmpt level?
why should we change cmpt level if we move database from sql2000 to sql2005 ?
cmpt is the database compatibility level.
70 for sql server 7.0
80 for sql server 2000
90 for sql server 2005
100 for sql server 2008.
The compatibility level has to be changed from 80 to 90 when you upgrade from sql server 2000 to sql server 2005 to fully use the new T-SQL features.
You also need to run upgrade adviser before upgrading to sql server 2005, which gives what are things you need to change before upgrade and after upgrade. Accordingly you to change your T-sql code.Some t-sql commands will not be run after you change the cmpt level to 90, which need to modify later.
thanks