Vishwamohan.NET

I have updated my BlogEngine from inline SQL statements to Stored Procedures. In order to do that I modified the MS SQL Server Provider class and wrote all stored procedures. If you like to upgrade your code, download the attached files and follow the steps: Login ... [More]

I came across a situation where I had to find all the stored procedures or user defined functions that do not have “execute” permission under a particular user. Here is a simple SQL Statement one which can be used under SQL Server 2005 to find those objects.. [More]

You might have come across situation when you wanted to log SQL Connections and Locks for a particular day or period. In the following example, by using two tables and one stored procedure, you can log these activities and analyze at a later time. This stored procedure can be turned into a SQL Job for any given interval so that you do not have to manually run it. . [More]

At some point you might need to know, how many tables you have in database, number of rows in each table, size of table and indices. Following is a simple SQL Script which can provide you a snapshot of all such details.. [More]