Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Compare the Data of 2 Tables (Improved) Expand / Collapse
Author
Message
Posted Thursday, November 8, 2007 11:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 7, 2003 12:00 AM
Points: 0, Visits: 1
Comments posted to this topic are about the item Compare the Data of 2 Tables (Improved)


Post #420380
Posted Thursday, April 9, 2009 12:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 27, 2012 6:32 AM
Points: 21, Visits: 97
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...
Post #694361
Posted Monday, May 3, 2010 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 7, 2012 1:12 PM
Points: 3, Visits: 38
Can this be used over a linked server as well. I have 2 tables on 2 different servers and want to compare them.
Post #914898
Posted Wednesday, May 12, 2010 7:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 7, 2012 1:12 PM
Points: 3, Visits: 38
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
Post #920439
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse