T-SQL Maintenance Plan Creation

Use this script ot be able to create DB Maintenance Plans fast. If you need to create the plans on servers similarly set up, edit the required parameters once, and when you create a new plan, you will only need to specify a database name and one task start time, run the script and the […]

Grant Object Permissions to Role/User in mult DBs

This script cycles through a chosen selection of databases, and grants permissions to all tables, views and stored procedures to a user or role.To use, change the ###text### to control which databases, permissions and the user/role concerned.

Script Login Roles Permissions in all DBs _SQL2005

Usage -Populate @list variable below with account(s),comma delimited list to script. -Save output to recreate:Login,Default DB,Server Roles,DB Access,DB Roles,DB Object Permissions. -- NOTE: -Stored procedures are created in Master, but are deleted -to limit by database see section /*Get a table with dbs where login has access*/ and change the where clause -to script all […]

Synchronize SID with Login SID - No CURSOR

Rebuild and Reorganize Indexes in SQL 2005

This SP rebuilds and reorganizes all indexes in the specified database or all databases. You can run code or generate code. Database will be set in bulk logged mode during processing and set back to normal when finished.Different SQL Editions are handled. LOB indexes, row and page locking options, number of processors, concurrent users and […]

Function Used to Reformat Phone Numbers

Can use this to select , insert and update phone fields into a standard format. Select FormatPhone(phone_column) from table Update Table set phone_column=FormatPhone(phone_column)Where ...Insert Into Table ( column1, phone_primary ...) Values ( 'qwerty', FormatPhone(1455846677)And the like --

Drop a Column and its Constraints and Indexes

Drops the specified column from the specified table as well as any constraints and indexes that depend on the column. By default the script will just find the corresponding column, constraints, and indexes.Comes in handy for patching databases.

Search All Columns in all tables

This script will quickly generate DML to search all the tables in the current database for a given string. It could be modified to execute the generated code if desired. If you are running this in a

Script for all Foreign Keys of all tables of a DB

Foreign Keys of all tables in a database? with? table? name? and? column? name??

SQL Server 2005 Upgrade Analysis Report Stylesheet

XSLT Stylesheet to produce developer/object oriented html report from SQL Server 2005 Upgrade Advisor xml report file. Name the script sqlupad.xsl and insert the following  as the first line in the xml Upgrade Advisor report file. Place sqlupad.xsl file in same directory as the xml report. This stylesheet works against Database Server component reportonly, does […]