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.
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 '10 at 07:54 AM
Seen: 924 times
Last Updated: Feb 23 '10 at 08:07 AM
How can I create a view with parameters?
Which stored procedure will we be running to add a linked server?
Combine contents of tables from several db into one view or sp
Consolidated: SQL Pass comma separated values in SP for filtering
insert line breaks into xml output of stored procedure
When to use view and stored procedures ?
store procedure error
Am I to assume there is a performance hit using UDFs compared to nested functions?
Return all tables and views used in Stored Procedure
In what scenarios would I need to use WITH ENCRYPTION?