Compatibility level

I have a sql 2000 db now running in sql server 2005.
The compatibility level is set to sql 2000.
If everything works should i leave it as is? or
Will changing it to sql server 2005 give me better performance?
HowardI don't think it is much to do with performance. Sooner or later you
do need to upgrade the database to the next level.
The compatibility level allows administrators to upgrade the system
while developers/3rd party company can still work on in-house
applications (make sure it is MSSQL 2005 compatible). It provides a
option for administrator (rather than wait for the developers to finish
the job, you can upgrade the system first and adjusting the
compatibility level later on when it is ready).
For examples, new reserved words introduced. Once you confirm the new
application has got rid of the reserved words, you can then safely
change the compatibility level to the latest which won't work in the
pervious version.
Mel|||Best option is to test your application on test server on SQL Server
2005 with compatibility level 90 and when it works satisfactory deploy
it on live.
Regards
Amish Shah