Disconnect All Users of a Database There comes a time in every DBA’s life when he or she has many users connected to a database that needs to be detached, placed in single user mode, or simply refreshed. The problem is they keep reconnecting more quickly than you can KILL them off. This is especially…
Tag: DBA
Sample Databases Available for Download
Whenever someone starts learning Microsoft SQL Server they always ask for a demo database they can connect to. If you don’t have access to one already there is hope. Search on amazon and see how cheaply you can find a copy of Microsoft SQL Server 2000 Developer edition. I’ve found them as low as $50. …