We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.  Read more...

Dynamically generate trigger DDL and write to individual SQL files.  Read more...

Use a hash to identify changes and process just the changed rows.  Read more...

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...

If you want to get the CREATE TABLES for all your Database tables, now you just need to run this SP.  Read more...

Function for splitting the values in string, applying logic and concatenating back to string.  Read more...

This script captures user authorizations by database (default) or by SQL instance   Read more...

This script finds all tables which contain IDENTITY property, and compares the current seed to the maximal boundary of the data type.  Read more...

Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.  Read more...

In this script, we can search a Field and Table in all databases on the server, returning the Field value.  Read more...

In this script, we can search a Field and Table in all databases on the server, returning the Field value.  Read more...

Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard  Read more...

This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.   Read more...

Determines if two instances of a Active/Active cluster are running on the same node.  Read more...

This script displays all data files within a SQL Server database with the following relevant properties: FileName, FileLocation, FileSizeMB, SpaceUsedMB, AvailableSpaceMB, %FreeSpace, FileGrowthMB and FileGroupName  Read more...

I'm no big fan of dynamic SQL or cursors, however there are times where they do the job.   Read more...

This procedure takes a login name and will generate the access and authorities for the login across the SQL instance.  Read more...

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...

This script converts a numeric column index to an Excel column name (ex: AC)  Read more...