SQL-Articles

Author: Sugeshkumar Rajendran

  • List Orphan ID’s

    This script displays the list of orphan SQL Server accounts from all the databases. This script is applicable for version greater than SQL 2000.

  • Check if /3GB is configured or not

    This script is used to check whether the 3gb switch is configured or not in the boot.ini file. This script is applicable for SQL server 2005 and above.

  • Permission List

    This script gives a detailed information about permission for users in a database. This output lists Object name, Schema name, user name and permission. This is compatible only to SQL 2000.

  • 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.

  • 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.