Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Replication Big Int issue

Author  Topic 

Robobz
Starting Member

1 Post

Posted - 2006-06-09 : 11:05:24
Hello,

I am reasonable new to using MS SQL Server 2000, however my replication which was fine has now started failing with the following error.

-------------------------------------------------------------
The merge process could not retrieve article information for publication 'omnimall'.
(Source: Merge Replication Provider (Agent); Error number: -2147201017)
---------------------------------------------------------------
Error converting data type bigint to int.
(Source: HEMP (Data source); Error number: 8114)

There is 700+ tables in the DB is there a way of resolving this or at least spotting where the large integer is?

Help!

Thanks

Rob

Kristen
Test

22859 Posts

Posted - 2006-06-13 : 02:00:06
Is it possible you have a column that is BIGINT in the publisher database and just INT in the subscriber database?

Maybe script both databases and compare the scripts?

Kristen
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-06-14 : 04:38:20
quote:
Originally posted by Robobz
... at least spotting where the large integer is?



Are you looking for this?

SELECT OBJECT_NAME(id)  [Table Name]
,Name [column Name]
FROM SYSCOLUMNS where TYPE_NAME(xtype) like 'bigint'


------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page
   

- Advertisement -