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.
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: 1420 times
Last Updated: Feb 23, 2010 at 08:07 AM
Am I to assume there is a performance hit using UDFs compared to nested functions?
Does anyone have an example of a CLR stored procedure calling a yes/no MessageBox and returning the value to the calling script?
stored procedure xml output
Getting biweekly periods, start_date and end_date
In what scenarios would I need to use WITH ENCRYPTION?
How can I create a view with parameters?
Why we create SSIS packages eventhough we can accomplish the same requirement in a SP or in sql statement
Can I tell when a stored procedure was last executed or who executed it?
optional paramenters in a procedure
Which stored procedure will we be running to add a linked server?