You are here: Re: SQL2005: Running TSQL commands in single-user mode « MsSQL Server « IT news, forums, messages
Re: SQL2005: Running TSQL commands in single-user mode

Posted by Plamen Ratchev on 12/21/07 00:35

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9A0CEDE5828E5Yazorman@127.0.0.1...
> Plamen Ratchev (Plamen@SQLStudio.com) writes:
>> 2). Use sp_who to find the session ID of the active connection and use
>> KILL to terminate it.
>
> Kind of difficult when Mike can't connect...
>

You are correct the way I wrote it... :) I meant more along the lines of
using DAC to run sp_who/kill and then use regular connection once available.

Plamen Ratchev
http://www.SQLStudio.com

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация