SQL Query – Find size for all tables in a Database

We have system procedure to get size information. Continue reading

SQL Query – Find a Column from all the Tables

Here is the query to find a particular column in all the tables for given database.
Continue reading

Single query to grant Read/Write/View permissions to all stored procs

–For SQL Server 2005 and above Continue reading

SQL Databases Last Backup Data and Time with Recovery Mode

Many times DBAs find difficulty to find out when did Last full backup or Transaction log backup completed on SQL Instance and If the SQL Instance has number of database its even more difficult to find out through SQL Enterprise Manager or Management Studio.
Continue reading

How to fix Orphaned Users in database

FIX : Error 15023: User already exists in current database

Introduction
Orphan user is a user in a SQL Server database that is not associated with a SQL Server login..

Continue reading

SP_recompile

SP_recompile needs a single parameter which is the table name after it.

ie: sp_recompile table_name Continue reading

Routine SELECT Queries

The below query to get result for SQL server Installation information Continue reading