THANKS for all the pointers. I'm not sure what to do here. I will keep all these things in mind!

Juanita

And you are right about other tools only showing what is necessary. We have CRYSTAL reports here which is great. but at the same time some people choose to use...

THANK YOU THANK YOU!!!! That was it!! I just copied the stored proc to another database and it ran fine. It just wasn't registering what I was doing and when...

Okay, in query analyzer here is the statement i'm executing in the context of MASTER:

EXEC [Webfaq].[dbo].[sprocWebfaq_Restore]

Now the actual stored proc looks like this:

 CREATE PROCEDURE sprocWebfaq_Restore  AS

-- Restore the...

HI. I have done the SP_WHO and there is no user, not even me, that has a session open with this database. i'm in query analyzer and i have NOTHING...

HI Guy,

I'm about to do the same thing on our test server. I found the sql server 200 service pack 3a readme document very helpful. it lists the system databases...

 Thank you so much!!! That will work!

Juanita  

Thank you so much for the clarification and for the tool suggestions!!

Juanita

THANK YOU SO MUCH!!!

would you know how this setting gets changed? This started a couple of months ago and we've had sql server a while now.

Just...

HI.. I was wrong, it didn't create the log file because of an error. so that must explain why i can't see the database listed. So can i just delete...

Steven,

Thank you so much. Just the answer I was looking for.

Juanita

Thanks so much.. I just gave it a try and I think that will work.

Thanks again!

Juanita

Thank you so much! That's exactly what I was looking for and I went to BOL and tried different keywords but not that combination. I've just made it one of...

Last night I rebooted the box that sql runs on and all the backups completed successfully from beginning to end. no processes left running. BUT on my test box i...

Steve,

It is sql server 2000 standard edition, service pack 2. I feel like this started when we changed our email to microsoft exchange server but i can't say for sure....