Lowell (9/5/2012)
i just tested it in 2008R2, 2005, and compatibility 80.change your database compatibility.
EXEC dbo.sp_dbcmptlevel @dbname=N'SANDBOX', @new_cmptlevel=90
try it in tempdb if you want, and it works fine, since tempdb will be the version of the server.
You are right. The database is set to be compatible with sql server 2000.