Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Programming > Database Programming > How to find unused stored procedures in sql server 2005?

How to find unused stored procedures in sql server 2005?

Answer:
There is no way to view this information by way of SQL Server Management Studio.
You could write a stored procedure against the SYSObjects tables to gather the information. You can also obtain information regarding the create / last accessed|used date of many objects from the same resources.
First answer by Jwilliamsoh. Last edit by Jwilliamsoh. Contributor trust: 57 [recommend contributor recommended]. Question popularity: 1 [recommend question].

Can you answer these Database Programming questions?

What is the difference between binary and hash tree? Answer it!
What command language used with relational databases? Answer it!
When may a database management package be preferred over a spreadsheet application package in business computing? Answer it!
What does the word and do when you are searching for something in your database? Answer it!
What is parameter file in oracle? Answer it!

Relevant answers:

Home

Answer these

Can one person get food poisoning and not the other if sharing same infected food?
In: Food Poisoning
Answer it!
What are the expedition in the Antarctica?
In: South Pole
Answer it!
Is there hops in Mike's Hard Lemonade?
In: Alcohol and Spirits
Answer it!
What is there relationship between measurement and evaluation?
In: The Difference Between
Answer it!
» more

Featured guides

» More