Dormant spid?

Can someone please tell me how a spid gets to be in a 'DORMANT' state? What
is the difference between 'dormant' and sleeping? It appears that the
'dormant' processes cannot be killed. Can't find anything on Microsoft's
website pertaining to this. Any help with this would be appreciated.
From MSKB 224453:
<Excerpt
href="http://support.microsoft.com/default.aspx?scid=kb;en-us;224453:">
Dormant Same as Sleeping, except Dormant also indicates that the SPID has
been reset after completing an RPC event. The reset cleans up resources used
during the RPC event. This is a normal state and the SPID is available and
waiting to execute further commands.
</Excerpt>
Hope this helps.
Dan Guzman
SQL Server MVP
"Farbro" <Farbro@.discussions.microsoft.com> wrote in message
news:DBCCEE89-AF96-4A20-B375-549AAECFB32A@.microsoft.com...
> Can someone please tell me how a spid gets to be in a 'DORMANT' state?
> What
> is the difference between 'dormant' and sleeping? It appears that the
> 'dormant' processes cannot be killed. Can't find anything on Microsoft's
> website pertaining to this. Any help with this would be appreciated.

Dormant spid?

Can someone please tell me how a spid gets to be in a 'DORMANT' state? What
is the difference between 'dormant' and sleeping? It appears that the
'dormant' processes cannot be killed. Can't find anything on Microsoft's
website pertaining to this. Any help with this would be appreciated.From MSKB 224453:
<Excerpt
href="">http://support.microsoft.com/default.aspx?scid=kb;en-us;224453:">
Dormant Same as Sleeping, except Dormant also indicates that the SPID has
been reset after completing an RPC event. The reset cleans up resources used
during the RPC event. This is a normal state and the SPID is available and
waiting to execute further commands.
</Excerpt>
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Farbro" <Farbro@.discussions.microsoft.com> wrote in message
news:DBCCEE89-AF96-4A20-B375-549AAECFB32A@.microsoft.com...
> Can someone please tell me how a spid gets to be in a 'DORMANT' state?
> What
> is the difference between 'dormant' and sleeping? It appears that the
> 'dormant' processes cannot be killed. Can't find anything on Microsoft's
> website pertaining to this. Any help with this would be appreciated.

Dormant spid?

Can someone please tell me how a spid gets to be in a 'DORMANT' state? What
is the difference between 'dormant' and sleeping? It appears that the
'dormant' processes cannot be killed. Can't find anything on Microsoft's
website pertaining to this. Any help with this would be appreciated.From MSKB 224453:
<Excerpt
href="http://support.microsoft.com/default.aspx?scid=kb;en-us;224453:">
Dormant Same as Sleeping, except Dormant also indicates that the SPID has
been reset after completing an RPC event. The reset cleans up resources used
during the RPC event. This is a normal state and the SPID is available and
waiting to execute further commands.
</Excerpt>
Hope this helps.
Dan Guzman
SQL Server MVP
"Farbro" <Farbro@.discussions.microsoft.com> wrote in message
news:DBCCEE89-AF96-4A20-B375-549AAECFB32A@.microsoft.com...
> Can someone please tell me how a spid gets to be in a 'DORMANT' state?
> What
> is the difference between 'dormant' and sleeping? It appears that the
> 'dormant' processes cannot be killed. Can't find anything on Microsoft's
> website pertaining to this. Any help with this would be appreciated.

dopping the database which is in emergency mode

I have a Database in suspect state and i have changed it to emergency mode and copied all the data and i am trying to delete it or renaming it so that i can recreate the db with the old name as my aplication will be looking for that database name.
When i tried to drop the database it says its in use and cannot be dropped.
And when I tried to rename it It gives me the follwoing message.

To change the NAME, the database must be in state in which a checkpoint can be executed.

Please advise me .

Thanks.Enterprise Manager likely still has a connection to the suspect database. Close EM, and drop the database via Query Analyzer (while logged into the master DB, of course). Just another reason why Enterprise Manager is evil.|||Did you identify the reason for Suspect mode?|||My data files and log files were corrupted and i dont have a backup for the DB. So I have placed the db in emergency mode and copied all the tables and data using query analyzer. But while copying the table and data i could not get all the constraints on the tables.

I have copied the tables and data using the following sql command

SELECT * INTO aaa from aaa.

How can i bring the db into active which is now in emergency mode.

Thanks.