you have to put 6500 in the max memory.

and you don't have to restart the sql

Perry Whittle (10/11/2008)

this is only true for the system databases. I use detach and restore all the time. When...

If you made a backup in sql 2000 you cannot restore it on sql 2005, only detach a sql 2000 and attach it on sql 2005

you can use a script like this http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31830/

to kill all connections to a database

You can try use the sp_blocker_pss80 :

http://support.microsoft.com/kb/271509

Thanks

The link seems not to work, any alternative to the link above.