• 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.

    Thanks...