I have inherited a database full of view's functions etc,etc. How ill i be able to determine when a object was last invoked and by what.
This will help me determine what is not used.
Feb 23, 2010 at 07:54 AM
Feb 23, 2010 at 08:07 AM
Kev Riley ♦♦
Similar question about stored procedures here : http://ask.sqlservercentral.com/questions/813
Similar question about views here : http://ask.sqlservercentral.com/questions/3756
Feb 23, 2010 at 08:01 AM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Feb 23, 2010 at 07:54 AM
Seen: 1176 times
Last Updated: Feb 23, 2010 at 08:07 AM
Return all tables and views used in Stored Procedure
stored procedure xml output
Does anyone have an example of a CLR stored procedure calling a yes/no MessageBox and returning the value to the calling script?
How can I create a view with parameters?
Getting biweekly periods, start_date and end_date
Can I tell when a stored procedure was last executed or who executed it?
Why we create SSIS packages eventhough we can accomplish the same requirement in a SP or in sql statement
Am I to assume there is a performance hit using UDFs compared to nested functions?
optional paramenters in a procedure
cannot execute function/stored procedure but can see it