Cool Tips‎ > ‎

Database Code Objects (Stored Procedures, Functions and Views)

 

Title

Description

Applicability

 

Get Database Code Object Metadata
Multiple queries for listing SPs, Functions, Views.  Includes code to search their code/definition


2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get SP Usage since last reboot

Get Stored Procedure usage since last reboot - possibly identify unused SPs

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 




Comments