Technical Article

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)

You rated this post out of 5. Change rating

2005-07-13 (first published: )

3,050 reads

Blogs

SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!

By

They run, they return data. So what? Some SQL queries just waste your time...

Copilot Outside of SSMS Seems to Work

By

I read Brent’s first look at SSMS and Copilot in there. He didn’t have...

A New Word: Falesia

By

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to...

Read the latest Blogs

Forums

Question about updating statistics

By SQL Guy 1

We have very large tables in our database, some even more 1 B records,...

Greener Grass

By Grant Fritchey

Comments posted to this topic are about the item Greener Grass

What tool or tools do people like for monitoring SQL servers?

By tschgc

I have a few tools at my disposal but none of them seems like...

Visit the forum

Question of the Day

A Basic Data API Builder ADD

What parameters are required for the dab add command in the Data API Builder?

See possible answers