'Logging' stored procedures/ views

[sqlturbo]

Hi all,

I have a database with over a hundred stored procedures, some of which I'm sure, are no longer needed. Likewise for the views. Is there a way to know which stored procedures or views are still being used by the users? That would help me getting rid of the ones no longer needed. Also, is it possible to log commands run against a database?

Thanks for any help.
L'tayn

 

[srinivasaraghavan]

Hi

Use sp_depends tablename

which will list the stored procedure and trigger depended on the table.


Srinivasa Raghavan


Srinivasa Raghavan

 

[tlbroadbent]

sp_depends doesn't ell if a procedure has been executed or a view utilized. SQL Server doesn't track this info. You can track commands executed using a SQL Profiler. See "Monitoring with SQL Profiler" at ...

http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_86ib.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.