Here is a copy of part of my recover plan:

2.      Stop SQL Server and SQL Server Agent from the...

Another point, if you change a field from char to varchar (enterprise manager) the spaces will remain from the old definition until they are removed.

Steve

Just an update, Red-Gate is looking into the problem and hope to have a fix for it.

Steve

Here's a script I put together that will Generate sql that will drop all the foreign keys:

SET NOCOUNT ON

print 'USE ' + DB_NAME()

print ''

-- Generate Drops for All Foreign...

I found a thread that was almost identical to mine on a Red-Gate forum.  I added to it at

http://www.red-gate.com/MessageBoard/viewtopic.php?t=1066&sid=34c6b162e6593d1b075671f06a9deaa4

Maybe they can figure it out.

Steve

noeld,

I believe you.  It just purplexing to get this script generated from Enterprise Manager after executing the statements:

ALTER TABLE plat_name NOCHECK CONSTRAINT ALL

ALTER TABLE plat_name CHECK CONSTRAINT ALL

---------------------------------------------------------------

if exists (select...

noeld,

You are correct that the script generated from Query Analyser drops the WITH NOCHECK syntax.  When I run a script generation from Enterprise Manager, it uses WITH NOCHECK on the...

DBCC CHECKCONSTRAINTS does sound like it can be useful, especially when you are adding a new contraint to a table, but I would prefer to keep the data clean to...

dcpeterson,

Thanks for the tip about ObjectProperty for Cascade Update & Delete.  It really cleans up the code.  Much better than using bitwise operator.

Steve

How about minimizing the amount of work that the trigger does.  Maybe write to a table the fact that something needs to be done with the appropriate information needed to...

I recently put together a script to generate rebuilding all the foreign keys for a database.  I will explore using the INFORMATION_SCHEMA objects to do same if I can.  Here...

I gave up trying to get the CHECK CONSTRAINT to work and decided to drop all Foreign Keys before reloading my test system, run the dts and add back the...

I don't get any error messages! It just says

"The command(s) completed successfully."

but when I compare the structure of production to test, the test shows

ALTER TABLE [dbo].[at_plPlatted_Lot] WITH NOCHECK ADD...

I understand that

ALTER TABLE at_plPlatted_Lot CHECK CONSTRAINT all

should be reactivating the contraint.  The problem is that it is not reactivating it.

I am reloading test, not production.  I do run SQL...

Both SQL Server and SQL Server Agent can be started up with a specific account instead of the system account.  Right click the Server in Enterprise Manager, chose Properties, Security...