why not?? it's only 190k rows... and the heart of the site .

Just take yours and we'll trust what comes up... and agrees with common physics laws .

There must be a message somewhere... But I can't think were it could be.

ISNULL(ColumnName, 0)

maybe a full outer join is required??

I see. Thanx for the info.

Don't know about that fix in SP4.

What error message are you getting when trying to reactivate the constraints?

I don't see an easy way out right now... seems to me that you'll need more than one query to pull this out (or a big bunch of left joins).

Seems...

That was my reference to the snapshot (copy sysobjects into a table, then at next run check to see differences between the 2 tables). Both you'd have to log,...

Maybe something like this?? : http://www.sqlservercentral.com/scripts/contributions/721.asp

Here's a working exemple. The data makes no sens but at least the query works :

Select * from NorthWind.dbo.SysObjects O inner join Pubs.dbo.SysColumns C on O.id = C.id

Can we see the procedure and see what it's really about?

ALTER TABLE at_plPlatted_Lot NOCHECK CONSTRAINT all

and

ALTER TABLE at_plPlatted_Lot CHECK CONSTRAINT all

Only deactivate and reactivates the constraints. It doesn't revalidate anything.

Do you have to do this on many tables??

Have you...

Are you talking about versions of stored procs/tables??

Cause this is something that is really better handled by carefully planed releases and code versionning kept in history. The only way...

NP... can't wait to hear the answer of my last message .