How to create SSRS Reports with Dynamic Connection 6. February 2013 Vishwa SQL Server, Reporting Services (0) If you had multiple databases and would like to dynamically use the connection string for SQL Server Reporting Services, how would you do it? Here are some steps [More]
Find Permission on all objects 18. July 2007 Vishwa SQL Server (0) 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]
Log SQL Connections and Locks 25. June 2007 Vishwa SQL Server (1) 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]
Calculate the table size and number of rows 1. June 2007 Vishwa SQL Server (2) 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]