List of your Stored Procedures and when they were last accesses.
Change the database_name at the top.
Change the where cause to match your name convention.
examples: usp_Name , csp_Name, etc.
v_bellomo,
2012-10-25 (first published: 2012-10-12)
List of your Stored Procedures and when they were last accesses.
Change the database_name at the top.
Change the where cause to match your name convention.
examples: usp_Name , csp_Name, etc.
Use Database_Name Go SELECT a.execution_count , OBJECT_NAME(objectid) Name, query_text = SUBSTRING( b.text, a.statement_start_offset/2, ( CASE WHEN a.statement_end_offset = -1 THEN len(convert(nvarchar(max), b.text)) * 2 ELSE a.statement_end_offset END - a.statement_start_offset)/2 ) , b.dbid , dbname = db_name(b.dbid) , b.objectid , a.creation_time, a.last_execution_time, a.* FROM sys.dm_exec_query_stats a CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) as b WHERE OBJECT_NAME(objectid) like 'sp%' ORDER BY a.last_execution_time DESC
Here's a general overview for creating and editing stored procedures. Head over to the discussion forum for this article and present your creative ideas for using this powerful feature of SQL Server to the SSC community.
2002-05-27
19,483 reads
Sp_readerrorlog can read any file on the hard disk, not just error logs. Read on to learn how!
The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.
2007-02-09 (first published: 2001-12-18)
39,653 reads
Designing your application so that Stored Procedures are the only database objects that are accessed is generally the best practice. Agree? Disagree? Read this article by guest columnist Mindy Curnutt to see what she thinks!
2001-08-01
12,462 reads
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
2001-07-20
2,008 reads