Ok, who locked the database?
by Geoff on Sep.09, 2011, under Coding, SQL
I work with six other developers. We don't have a SQL DBA per se. This means that sometimes my colleagues or even myself will have open SPIDs preventing a SQL RESTORE.
So, who locked the database?
select spid, status, loginame, hostname, blocked, db_name(dbid), cmd, * from master..sysprocesses where db_name(dbid) = 'database name'
-
Hi! Welcome to Epic Puck!
Thanks for dropping by! Feel free to join the discussion by leaving comments, and stay updated by subscribing to the RSS feed. See ya around!
GM-VOLT : Chevy Volt Electric Car Site- Low-cost Revolo bolt-on, plug-in hybrid system touted for its potential
- A time to reflect on the Volt — my first fill up
- Chevrolet Volt and Vauxhall Ampera win Diesel Car’s Best Eco Car of the Year
- Consumer Reports says Volt and Focus EV compromised, unlike ‘purpose-built’ EVs
- Electric Vehicle Symposium (EVS26) Report
