Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
How to find the Recently accessed stored Procedure?
September 11, 2010
In our production database, i have to find the recently accessed stored procedure, Can any one give me the Sql Server Script to find it out.
Posted Date: September 17, 2010 Points: 5
As far as I know, the profiler is the only built-in tool in SQL to do this task. You are right. We cannot afford running the profiler against a large and heavily used database, in general. But we can set filter only focus at specified objects, such as stored procedures while running the profiler.
To post reply
Related Questions Related Questions
i got a problem on registration form using stored procedure and classes
How to get output value from stored procedure?
Table name as parameter in SQL Stored Procedure
get value from output parameter from stored procedure
How do I call a Stored Procedure with one associative array as Out put Parameter ?
Where will the text of the stored procedure gets stored?
What is Precompiled in terms of Stored Procedure in Sql Server?
Difference between Stored Procedure and function in Sql Server
Can we have a Stored Procedure and a table with a same name? if not why?
How to pass dynamic dates to pivot query through stored procedure
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend