|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898,
Visits: 1,049
|
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Monday, May 21, 2012 3:13 PM
Points: 516,
Visits: 1,563
|
|
Perhaps a correlary script to disable contraints and triggers when copying large amounts of data from one database to another is
sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all" go sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all" go sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all" go sp_msforeachtable "ALTER TABLE ? ENABLE TRIGGER all" go
Steve
|
|
|
|