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,901 reads

Blogs

3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution

By

This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...

The PowerBI Volleyball Report – Organizing Data To Start

By

One of my goals this year was to build a report that I can...

Daily Coping 2 Aug 2021

By

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

Read the latest Blogs

Forums

Import CSV Data Into Existing Tables

By VSCurtis

Hi Guys, I am having issues trying to import data from CSV files into...

Function not returning all data.

By David C Young

I inherited this code. Written by a 3rd party. I have 3 servers, 1...

Need to change RS Execution Acct PWD, automatically w/ T-SQL

By Express12

We use a 3rd party vendor to administer our SQL Server service account PWDS....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers