Create Table DDL via TSQL

A stored procedure from longtime community member Lowell Izaguirre, returns the CREATE TABLE definition for any table, including PK, UQ, Identity, FK, Defaults, and more.

PowerShell To Get Active Directory Users And Groups into SQL

Use Powershell to query AD for Users, Groups and GroupMembers

Enumerate Windows Group Members

Here a quick script showing how to get all the Active Directory users in a AD group.

Deep Dive into Changing Database Collation

Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.

sp_rename and the procedure definition

Reverse Engineering a Server Side Trace

How to reverse engineer or script a trace for disaster recovery, or simply scripting for enhance and adjustment.

Get DDL for any SQL 2000 table

a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.

Get DDL for any SQL 2005 table

returns CREATE TABLE script for any table. including schema name,calculated columns,
indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.

TEXT/NTEXT Find and Replace

Find And Replace any string, in the entire table with this function. Parameterized for easy use.

Default Trace Load of All 5 Files

The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.