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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close