Is there an update to this procedure? The table master.dbo.spt_datatype_info does not exist, or is not visible in 2005.
I get the following error messages:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'master.dbo.spt_datatype_info'.
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "MyServer" does not contain the table ""master"."dbo"."spt_datatype_info"". The table either does not exist or the current user does not have permissions on that table.
If no update is available, what table replaces master.dbo.spt_datatype_info?
I need a procedure to compare two tables on different servers where I can pass the table names as parms and receive back a list of the differences. Ideally, it should return the key values and only the data from the columns that are different.