This came up today and I didn't know exactly how to properly do it.<BR><BR>The situation: We were to move a database from a MS SQL 2000 server into our in house MS SQL server and run the restore to ...

I've been able to move databases with sp_detach and sp_attach. Obviously, connections to that database will be dropped, but it shouldn't affect any others.

As an IT professional working for a small to mid-sized organization you are not only in charge of the servers, desktops, firewalls, routers, switches and mobile devices… you’re the chief, cook and ...