In this tip we will look at one way to achieve control of stored procedures to ensure that reuse is for the intended purpose and changes do not break other applications that may be using this same code.  Read more...

List of your Stored Procedures and when they were last accesses.  Read more...

I have implemented following stored procedure which is providing the object wise last used date of all databases which is available in single instance.  Read more...

Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables  Read more...

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.  Read more...