Technical Article

Foreign Key DDL wizard

This script can be run when you want to do batch processing on a database, such as a dynamic truncate statement for all tables in your database.  This script will actually script all the Foreign Keys in your database, and then store them into a table called FOREIGN_KEY_TEMP.  It will then generate, and execute, all […]

2004-01-22

231 reads

Technical Article

Generate all database table DDL

This script starts in the master database, and then goes to each USER database and creates the DDL for each USER table in every database.  You can then save the results or copy them to a new query window to run on another server.

2003-11-14

458 reads

Technical Article

Generate all database foreign keys

This script will create another script that has all foreign key DDL that exists in a given database.   You only have to run this, and then select the results of this script and paste it into another query window, or if for some reason you have lost your DDL this will enable you to retrieve […]

2003-11-12

228 reads

Blogs

New Job -> Week 3 -> Creating Alerts

By

This is part of a series of new job blog posts. You can find...

Using SQL Alerts to Spot Suspicious Activity in SQL

By

SQL doesn’t really give us too many tools out of the box to allow...

How to Change the Browser Used by SSMS for AAD Auth

By

Did you know that you can change the browser used by SQL Server Management...

Read the latest Blogs

Forums

Matching the table

By sathishkm

Hi All, I have two table called TableA and TableB. Here I need to...

Pivot and group by sum sql

By HeftSteady

Hello,  I am trying to build an output that takes data from a table...

Minimal DOP Feedback

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Minimal DOP Feedback

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers