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 '10 at 07:54 AM
Feb 23 '10 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 '10 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.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Feb 23 '10 at 07:54 AM
Seen: 653 times
Last Updated: Feb 23 '10 at 08:07 AM
store procedure error
Getting biweekly periods, start_date and end_date
Return all tables and views used in Stored Procedure
Can I tell when a stored procedure was last executed or who executed it?
Am I to assume there is a performance hit using UDFs compared to nested functions?
In what scenarios would I need to use WITH ENCRYPTION?
cannot execute function/stored procedure but can see it
Combine contents of tables from several db into one view or sp
Consolidated: SQL Pass comma separated values in SP for filtering
When to use view and stored procedures ?
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.