Generate Insert Statements

If you wish to save the contents of your database as insert statements, this script will generate a text file that has all data formatted as insert statements. This way you can save off the data as a script to send to a client or combine with a create script to rebuild the database on […]

2005-07-29 (first published: )

836 reads

Generate Quick Snapshot of table structures.

I use this script to quickly compare databases. In the past, I would generate creation scripts and compare those but that is tedious at best. This script generates a report of the metadata in an easy to read format that includes...- Table and Field Listing with types.- Foreign Key information- Primary Key and Index information- […]

5 (1)

2005-07-28 (first published: )

573 reads

Blogs

On Dynamic Ports, Named Instances, and Firewalls

By

Recently I had a client and their vendor trying to configure a firewall for...

Daily Coping 13 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Read the latest Blogs

Forums

The C in ACID

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The C in ACID

Renting Features

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Renting Features

Basic Git for DBAs: Making Changes in GitHub

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Basic Git for DBAs: Making...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The C in ACID

See possible answers