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