That is what we do too. Use the new server name.

So what is the better option ?

So, what exactly...

But when we have our reindex jobs at weekend maintenance plan, it seems it used space that double the size of the databases?

Space in the data file or space in...

Almost. The first statement will ensure that new data is checked. With that, any new rows that don't meet the constraint will fail

The second will go back and check existing...

Thanks all.

Thanks all,

So the first statement is to insure the constraints can be created.

The second one enables the foreign key and will check both exisiting and new future data.

If it finds...

With NoCheck means the constraint is not evaluated against existing data.

Second alters the constraint, enabling and checking the existing data (as per previous quote).

Two statements so that the constraint will...

Or does the first statement mean we add constraints without checking existing data.

the second mean for future new records, check constraints?

Is that right?

Thanks

Sorry, I still don't understand it.

The first is to add constraints without checking existing data.

What does the second do, check constraint??

Why first one not check, the second check...

Thanks a lot

Thank you, sorry it is kind of hard to understand the memory configuration.

But from what paul.knibbs said to set to max 2.5 GB, but opc.three said to set it to...

EditionProductVersionProductLevelphysical_memory_in_GBVAS_GBbuffer_pool_committed_memory_in_GBbuffer_pool_target_memory_in_GBmin server memory (GB)max server memory (GB)

Standard Edition9.00.3068.00SP23.502.001.551.550.012097152.00

output

OS Name: Microsoft(R) Windows(R) Server...

Sorry, I see that one didn't get answered for a while, so start a new one described more clearly

Attached is the result

We only had 2 GB memory.

So after we extended 4 gb, will that help with SSIS?

How about the quoted error message in my original post? How to fix that?