|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Disconnect Client Connection via T-SQL/Store ProceHi Gents,
If there are some client connections on the database and I would like to detach the file, it's failed when execute the store proc "sp_detach_db". Any SQL statement or Store Procedure on clearing/kicking out the current client connections? Thanks in advance. Regards, CurtisL Are all your drivers up to date? click for free checkup Moreover, using kill <id> with statusonly. So this way I can see the rollback
progression out of danger. Show quoteHide quote "markc***@hotmail.com" wrote: > > You can use the KILL command. > > ALTER DATABASE <bd> SET SINGLE_USER with rollback immediate
and then ALTER DATABASE <bd> Set MULTI_USER Got it, thanks.
Show quoteHide quote "Enric" <En***@discussions.microsoft.com> wrote in message news:E1D27BFF-57E1-4DEC-8D29-D9DF90A799DD@microsoft.com... > > ALTER DATABASE <bd> SET SINGLE_USER with rollback immediate > and then > ALTER DATABASE <bd> Set MULTI_USER >  
Other interesting topics
Concatenating:www.aspfaq.com/show.asp?id=2529 Is the glass half full or half empty or..?
Query help - resultset too large... impossible! Used Disk Space reporting and sending Email Problem updating two tables in a transaction. Query assistance or advice Any way to avoid using a cursor and a script on this one? Optimizing query with UDF and table vars and IN Please help with SQL query Misunderstood INSERT when using CASE on ORDER BY Temporary Tables |
|||||||||||||||||||||||
