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)

2005-07-13 (first published: )

2,978 reads

Blogs

Daily Coping 23 Mar 2023

By

Today’s coping tip is to focus your attention on the good things you take...

SQL Bits 2023 Recap

By

I had an amazing time adventuring to Wales with other members of the data...

Converting Types in C#

By

I am not a great software developer. I’m OK, and I do know how...

Read the latest Blogs

Forums

Converting To/From User Friendly Trigesimal Geocodes

By Todd M. Owens

Comments posted to this topic are about the item Converting To/From User Friendly Trigesimal...

AG listener error

By roshanbi

Dear Support,   could you please advise why error below prevents me from adding...

Email using msdb..sp_send_dbmail

By rjjh78

Hello,   I have a data export process using msdb..sp_send_dbmail.  Most fields come out...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers