I'd create a linked server, create a cursor bwteen the 2 catalogs (I can't figure it out with the INFORMATION_SCHEMA views...anyone?)The create a cursor and build a sql string that will identify the missing rows....EXEC sp_addlinkedsrvlogin 'Tax_Dev', 'false', NULL, 'sa', 'password'CREATE CURSOR myCursor99ASSELECT LocalTableName, LocalColumnName, LocalColId , RemoteTableName, RemoteColumnName, RemoteColIdFROM ( SELECT o.[name] AS LocalTableName, c.[name] AS LocalColumnName, c.colid AS LocalColId FROM Northwind.dbo.sysobjects o INNER JOIN Northwind.dbo.sysColumns c ON o.[id] = c.[id] WHERE o.xtype = 'U') AS LJOIN ( SELECT o.[name] AS RemoteTableName, c.[name] AS RemoteColumnName, c.colid AS RemoteColId FROM Tax_Dev.Northwind.dbo.sysobjects o INNER JOIN Tax_Dev.Northwind.dbo.sysColumns c ON o.[id] = c.[id] WHERE o.xtype = 'U') AS RON LocalTableName = RemoteTableNameAND LocalColumnName = RemoteColumnNameORDER BY 1,3
I'd write the wole thing, but it'd take a bit....Brett8-)