Drop and Add Foreign Keys

Have you tried using DTS to load a database and those pesky foreign keys mess you up? This is actually two scripts, one to generate the SQL needed to drop all the Foreign Keys in a database and another to Add the Foreign Keys back when you are done. I've thrown in Disabling and Enabling […]

5 (9)

2005-07-13 (first published: )

2,881 reads

Blogs

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

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

Read the latest Blogs

Forums

Why are DBAs not paid for knowledge and other IT Professionals are?

By Engineer

DBAs are being asked to know everything for 6 figures which cap out for...

Common Table Expression Misunderstandings

By Kathi Kellenberger

Comments posted to this topic are about the item Common Table Expression Misunderstandings

Distributed AG DB movement

By Syed_SQLDBA

I have a DAG between On prem and Azure. We have a maintenance window...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers