Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How do I find in use db objects from all application pages is there any tool or trick I can use, just like we do search in Visual studio for an object in entire solution

share|improve this question
There is nothing in SQL Server that will tell you if something is or isn't used. Objects range from UDFs, SPs, Tables, Indexes, Statistics, etc. That's quite a lot of objects. Can you be more specific in your question? –  Sean Gallardy Jul 6 at 18:31
If I only talk about two type of Database objects, tables and Stored procedures –  AA.SC Jul 7 at 8:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.