mish_b20 (6/4/2008)

---

Hello ,

In order to see if the tables aren't identical you don't have to make so sophisticated script.
My suggestion to you is like this :


declare @data table( Table1 nvarchar(max), Table2 nvarchar(max) )

insert into @data
(Table1,Table2)
select
( select * from
db1.dbo.GalleryCategories as tbl
for xml auto
) as Table1,
( select * from
db2.dbo.GalleryCategories as tbl
for xml auto
) as Table2

SELECT CASE
WHEN count(TablesDataCompare.Table1)>0 THEN 'Yes'
ELSE 'No'
END
[Is Identical Tables?]
FROM
( SELECT Table1,Table2
FROM @data
WHERE Table1=Table2
) TablesDataCompare

When running the script you will see if the tables data are identical or not identical

Good luck.
Michael
:)