Sugeshkumar Rajendran – Page 8

Server Property

This will list out the server properties of your sql server including the account under which your services run. This is compatible to SQL 2000 and 2005.

January 17, 2008

Table Space Details

This script will list out the details of the space used by each in a database.This is compatible to SQL 2000 and 2005.

January 17, 2008

Scripting User Level Permission SQL2005

This script gives a out script that can be used to script out the existing user permissions in a database.This is compatible only to SQL 2005.

January 17, 2008

Scripting User level Permission – SQL2000

This script gives a out script that can be used to script out the existing user permissions in a database.This is compatible only to SQL 2000.Don’t forget to change the database name in parameter @dbname before using the script.

January 17, 2008

Connection Property

This script will list out the current connections on SQL 2005

January 17, 2008

Author: Sugeshkumar Rajendran

Server Property

Table Space Details

Scripting User Level Permission SQL2005

Scripting User level Permission – SQL2000

Connection Property