DB Locked?

• Martin D. Cymerman

  SSCrazy

  Points: 2079

  More actions

  January 24, 2007 at 6:40 am

  #75120

  I have a DB that when you try and view its tables, stored procedures, users etc it locks up. It is not marked as suspect and the diagnostics I have run shows that everything is ok. I have checked the error logs (SQL and NT) and I can see nothing that indicates a problem

  It’s the only DB out of 30 that does this. Any ideas would be appreciated.

  CY

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  January 24, 2007 at 7:07 am

  #685188

  Hmmm... Is it anything like the other 30?

  What if you put it into read only mode? Does it still lock then?

  What are you using to view the tables, stored procs, etc? Query Analyser / Enterprise Manager / Management Studio?

  If either of the latter, try running as a SQL query

  select * from information_schema.tables - does this return?

  Also, whilst frozen, open another connection to the server and run sp_who2 & post the results. Cheers

• Martin D. Cymerman

  SSCrazy

  Points: 2079

  More actions

  January 24, 2007 at 7:28 am

  #685201

  Thanks for the input. I found the problem. One of our developers started a tranaction and nerver closed it out. It just kept the lock open...

  Thanks

  CY