Q
Problem solve Get help with specific problems with your technologies, process and projects.

Listing invalid objects

I would like to list all the invalid objects (stored procedures, functions) in the database. How can I do it?

I'm not sure what an invalid object is. If it is in a database, it is a valid object. The definition of an invalid...

object would be a business decision. Now, if you are looking to get a list of object by type, this can be done from the information schema views. Depending upon the object type, you would use a different view. All of the information schema views are detailed in Books Online.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close