SQL Server Error 15234 Object is stored in sysprocedures and has no sp

[aalmeida]

I have a sproc that goes to all DBs in the server and makes a list of all objects, but recently it started to fail with (Error 15234) Object is stored in sysprocedures and has no space allocated directly. [SQLSTATE 42000] (Error 15234). Does anyone have seen this before? and how can it be solved?

Any help will be apreciated.

Thanks,

AL Almeida
Senior DBA

http://www.saxotech.com/

"May all those that come behind us, find us faithfull"

 

[mrdenny]

That's a new one. What does DHCC CHECKDB tell you?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com