Script tables to emulate Copy in Enterprise Manage

This script will produce the same output as doing a Copy in enterprise manager and then pasting into Query Analyser.It can handle Clustered and Nonclustered Primary Keys, Multiple Foreign Keys, Defaults, Constraints, Identity Fields.  If you are able to improve this script, or find any bugs, please let me know.

2003-04-09

162 reads

Blogs

Your First Jupyter Notebook

By

In April, I said I was going to start learning Jupyter Notebooks. It’s November....

Using Visual Studio Code

By

I’m a creature of habit. I have my routine when I get to my...

Docker Containers and Persistent Data

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

SSRS Enterprise vs Standard Edition

By TUellner

I need to install SSRS for report development and deployment. I don't work with...

Suspended session

By IMary

Hi, Application service is going to hung state and when we check the database,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers