Modeblue

In MSSQL2k, a lot of users would use the detach command within the GUI to kill all the active processes on a DB, this functionality is somewhat cut down in MSSQL2005 – you can see the processes & kill them individually, but not as a bulk kill.

To detach a database in Tsql, you can use:
EXEC sp_detach_db 'database', 'true'
This will detach the DB and skip checks on doing so.

Read the rest of this entry →

SQL Server 2005 has the same 3 types of logins as earlier versions of SQL Server. It also adds logins mapped to certificates and asymmetric keys.

Read the rest of this entry →