rprise manager inizializing hourglasse for hour and hourRun Query Analyzer, do a sp_who or sp_who2. Check the block column. I'm
guessing one of the processes is blocking another.
Be careful of what you do. Restarting SQL could throw a database into
recovery for awhile.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Massimiliano" <anonymous@.discussions.microsoft.com> wrote in message
news:EEFCD2AC-C6B0-4803-8B75-495442F780DC@.microsoft.com...
quote:
> I'have 300 DB in my SQL Server 2000 but now i can't view my DataBase in
Enterprise manager inizializing hourglasse for hour and hour|||Also, verify that you don't have autoclose database option on the server
side or ODBC tracing running on the client machine.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Andy Svendsen" <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:uvL1Gpc5DHA.1632@.TK2MSFTNGP12.phx.gbl...
quote:
> Run Query Analyzer, do a sp_who or sp_who2. Check the block column. I'm
> guessing one of the processes is blocking another.
> Be careful of what you do. Restarting SQL could throw a database into
> recovery for awhile.
> --
> ****************************************
***************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.NOMORESPAM.yahoo.com
> Please remove NOMORESPAM before replying.
> Always keep your antivirus and Microsoft software
> up to date with the latest definitions and product updates.
> Be suspicious of every email attachment, I will never send
> or post anything other than the text of a http:// link nor
> post the link directly to a file for downloading.
> This posting is provided "as is" with no warranties
> and confers no rights.
> ****************************************
***************************
> "Massimiliano" <anonymous@.discussions.microsoft.com> wrote in message
> news:EEFCD2AC-C6B0-4803-8B75-495442F780DC@.microsoft.com...
> Enterprise manager inizializing hourglasse for hour and hour
>
