Compare the Data of 2 Tables (Improved)

Question

Post reply

Compare the Data of 2 Tables (Improved)

BCStaley

Newbie

Points: 8
More actions
November 8, 2007 at 11:43 pm

#176758

Comments posted to this topic are about the item Compare the Data of 2 Tables (Improved)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mpv-1060508 SSC Eights! Points: 885 More actions · Answer 1

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

PHSDBA Grasshopper Points: 19 More actions · Answer 2

Can this be used over a linked server as well. I have 2 tables on 2 different servers and want to compare them.

PHSDBA Grasshopper Points: 19 More actions · Answer 3

mpv-1060508 (4/9/2009)
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...

Was wondering if you ever recieved an answer to this question. i am having the same issue

Thanks