moving a database

Using SS2000 SP3. I'm trying to move a database using:
EXEC sp_detach_db 'vesta_archive', 'false'
but I get a "cannot detach the database 'vesta_archive' because it is
currently in use."
There is no one here and no dts packages running. Is there any way to tell
who might be using the database or is there maybe another reason for this
message?
Thanks,
Dan D.
Try sp_who, and then look at column loginame, and dbname column.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.
|||Dan,
When I get such a message it is often me.
Do you have Enterprise manager open to that database? Another Query
Analyzer panel that is in that database? Etc?
Russell Fields
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.
|||Thanks. I found the culprit.
"Gregory A. Larsen" wrote:

> Try sp_who, and then look at column loginame, and dbname column.
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>
|||Thanks. I found the person.
"Russell Fields" wrote:

> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>
|||Russell, I agree. It's often the DBA. Sometimes even if you switch the
highlight to a non database object in Enterprise Manager, sp_who2 still
shows you are connected. In this case, I have to disconnect ...
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23s7UjDfhEHA.1184@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
tell[vbcol=seagreen]
this
>
|||More information needed than this.
|||Arc Serve has a database containing the information of the datastore
including indexes references etc. This is needed if a restore is going to
be done. I would like this database that arcserve creates to be put into
an SQL database, instead of residing on my local drive.
"unc27932@.yahoo.com" wrote:

> More information needed than this.
>