Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.

Ways to minimize sort operations

In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.

Predict the outcome

Primary Keys

Changing Primary key names to standard naming convention across the DB

This script will rename the Primary keys to standard notation - PK_TableName

Create/ drop unique key

This script will show you how to create/ drop unique key.

Getting unique or primary key columns for a given table

Following script will list out all the columns which have unique/primary key constraints for a given table.

Generate Insert Statements

This script Generates the insert statements for a particular table.

Add Primary key

This Store procedure is used to add primary key to all tables in a database, if table does not contain it.

RE: How T-Sql to Notepad???

I don't understand what you are trying to accomplish, if you open notepad everytime the trigger fires it's gonna open notepad on the server (not the client's computer). Why do you need to do this task (maybe we can offer a better solution)?