I have moved a database from sql 2000 to sql 2005.
I have changed the compatibility to 2005.
I also believe you need to run the command sp_updatestats as 2005 doesn't recognise so things in 2000.
how do I run a command in SQL 2005
Thanks in advance