SQL–List users currently logged in, and kill process commands.
List users:
select spid, status, loginame, hostname, blocked, db_name(dbid), cmd from master..sysprocesses where db_name(dbid) = 'SHTDRIFT'
Kill:
EXEC('KILL 57')
Search
Labels
- Windows Server (33)
- Microsoft Exchange (21)
- SQL (17)
- Windows Client (16)
- software (13)
- powershell (10)
- virtualisation (10)
- backup (6)
- scripts (5)
- network (3)
- printers (3)
- Hardware (2)
- Cloud (1)
- IT Strategy (1)
- Internet Information Server (1)
- SAN (1)
- mac (1)
Subscribe
Posts
Comments
Archive
-
►
2010
(27)
-
►
April
(8)
- Brilliant USB password cracker for XP and Vista.
- How to use Google's free SMTP server
- Restore deleted public folders in exchange 2003
- Set up of E-mail relay in Exchange 2007 (sbs 2008)...
- Install printers in Windows 7 XP mode
- Rebuild indexes, update stats and shrink script
- The anatomy of the SQL Cursor.
- Shrinking the space used by SQL databases.
-
►
April
(8)
0 comments:
Post a Comment