<div>
Thanks so much for all of your help! ScottPletcher, your solution seems to have worked wonderfully!
</div>


Thanks so much for all of your help! ScottPletcher, your solution seems to have worked wonderfully!

<div>
<div class="content wysiwyg-content">
I am unable to stop MSSQLSERVER!!! Please Help!<br />
<br />
I was attempting to drop a constraint from a table and got a lock request time out exceeded. I made sure no one was logged into the DB (exept me) and then killed (using kill spid) all of the open connections. I attempted to drop the constraint again with the same result. I thought since no one is connected to the DB I will stop and start SQL using the service manager but MSSQLSERVER changes to &quot;Stopping...&quot; but has yet to stop (1 hr 20 min later).<br />
<br />
I am lost on what action to take next. Any help is much appreciated!<br />
<br />
Thanks!<br />
&nbsp; &nbsp;- Marc
</div>
</div>


I am unable to stop MSSQLSERVER!!! Please Help!

I was attempting to drop a constraint from a table and got a lock request time out exceeded. I made sure no one was logged into the DB (exept me) and then killed (using kill spid) all of the open connections. I attempted to drop the constraint again with the same result. I thought since no one is connected to the DB I will stop and start SQL using the service manager but MSSQLSERVER changes to "Stopping..." but has yet to stop (1 hr 20 min later).

I am lost on what action to take next. Any help is much appreciated!

Thanks!
   - Marc

Unable to stop MSSQLSERVER!!!

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.