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: 973 times
Last Updated: Feb 23 '10 at 08:07 AM
Why we create SSIS packages eventhough we can accomplish the same requirement in a SP or in sql statement
In what scenarios would I need to use WITH ENCRYPTION?
optional paramenters in a procedure
How can I create a view with parameters?
cannot execute function/stored procedure but can see it
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 ?