June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Stored Procedure
I usually run following script to check if any stored procedure was deployed on live server without proper authorization in last 7 days. If SQL Server suddenly start behaving in un-expectable behavior and if stored procedure were changed recently, following script can be used to check recently modified stored procedure.…
Read More

SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
SQL Server can do some intense Mathematical calculations. Following are three very basic and very necessary functions. All the three function does not need explanation. I will not introduce their definition but will demonstrate the usage of function. SELECT PI() GO SELECT POWER(2,5) GO SELECT POWER(8,-2) GO SELECT EXP(99) GO…
Read More

SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Scripts, SQL Utility
I have received six emails in last four days asking for the resolution of error when tried to open newly installed SQL Server Book On-Line. Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9 1) Uninstall the versions of Book On-line (different languages, different releases etc) using…
Read More