Error to show Stored Procedures list in managment studio

• david.mejias

  Valued Member

  Points: 61

  More actions

  January 7, 2011 at 1:40 pm

  #144278

  HI,

  I have this problem in SQLServer 2005 management studio:

  In a databse tree i click on Stored Procedures tree and the follow message appears "Value cannot be null"

  Parameter name: context (ObjectExplorer).

  This happens just in one DB

  Does anybody knows why is this happening.

  Regards

  David.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 7, 2011 at 1:41 pm

  #1270903

  Sounds like a problem with the metadata for the database. Have you run DBCC CHECKDB on it?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• david.mejias

  Valued Member

  Points: 61

  More actions

  January 7, 2011 at 1:54 pm

  #1270915

  Thanks for answer

  Here is the result:

  CHECKDB found 0 allocation errors and 0 consistency errors in database 'BacSwapSecurity'.

  DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  Regards

  David

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  January 7, 2011 at 9:09 pm

  #1271025

  Please check if any of the workarounds listed here are useful.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga