Error 913

OS: Win2K3 x64 SP2
SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
I changed a database to single user, and the machine hung for over two
hours, to I stopped the program. Now I get an error saying 'Could not find
database ID x. Database may not be activated yet ot may be in transition.
Error: 913.
Does anyone have an idea of how to fix this?right click database, tasks, take offline. Then same thing only bring
online.
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
>|||Hi
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
My assumption is that stopping the process did not release the connection in
which case,
if you executed sp_who from a SSIS query window you may see one process
using the database, issue a KILL on the spid would allow a different process
to use the database.
John