Find Objects

sp_GetLoginInfo

Returns SQL server logins as a runnable script. Not a cleanup script. (updated 7/14/2004 to handle longer passwords that occurred in a previous service pack.)

List User 's Permissions in Database

Do you ever need to look for a given user's permissions for security reasons or move the permissions for that user from test environment to production? This is a script, which will generate print statements, which can be use to view/grant, the permissions of all dbo objects, which the given user has, which is not […]

Locate missing columns across entire server

This script will help you locate columns that you provide in a comma delimited format.  You pass it as few or as many columns as you want in the following format: ',,....' and this will generate you a report that states which database, and table each column you passed is in. 

create excel-html file from SQL SERVER

Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation

DATABASE / TABLE SIZE ESTIMATER

The code in this procedure takes standard formula’s given by Microsoft and calculates approximate size of a table as per the fields  & indexs on that table. The procdure can be quickly be used in a loop to work for entire database. Refer to article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp for the actual document containing the formula’s used.There are […]

Execute T-SQL Asyncronously

The purpose of this SP is to provide a method in T-SQL to launch another T-SQL thread without havingto wait for its completion. Uses fairly basic calls to create and execute SQL Jobs. Contains helpfull notes and documentation.

Find Replicated columns of certain data types

Script to look at all articles in all publications in a DB to find replicated columns of certain data types.  I used this to find BLOB columns that we wanted to remove from the articles.

Generate Strong Passwords for Standard SQL Logins

This script will generate random Strong Passwords for all Standard SQL Logins for a specified SQL Server.  It currently does ALL standard logins, including SA, so you would want to add to the WHERE clause in the SELECT_LOGINS constant if you want to limit the logins.  The password generated will be 10 - 15 characters […]

Check DB into VSS

I use this VBScript to get a DDL copy of all objects in my DB, and check them into SourceSafe if they have changed. I run it via Scheduled Tasks every night.  Make sure unauthorised users have no access to the script location, as you need to enter the VSS password in it.