Re: datatype conversion error in sql 2000 replication

oops, I shouldn't post just before I'm going to bed. I meant to say "that
could be it, it might have too many columns" and in fact it turns out it does
have too many columns. It has 247 columns - way too many. I tried looking for
that article again but couldn't find it again - looking forward to reading it.

"archuleta37" wrote:

That could be it, it might need more columns. I'll check as soon as I get a
chance. I tried to search for the kb article you reference but got no
results. Could you have a typo in the kb number? Could you post a url to read
the article?

"Raymond Mak [MSFT]" wrote:

If your table has many columns, you are probably running into a limitation
in SQL2000 which is addressed in QFE build 8.00.2209. You can either contact
Microsoft support for the QFE fix (KB923563) or you can upgrade to SQL2005
which doesn't have this limitation out of the box.

-Raymond

"archuleta37" <archuleta37@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:21837EA5-B4B2-479F-8AF2-D7A42593F3DC@xxxxxxxxxxxxxxxx
Hilary,
I'll have to check to see what I can give you from the schema, but here's
the last command that sql said it ran:

if (@@microsoftversion >= 0x080002C0) begin exec sp_addsynctriggers
N'PURGED_MGMT_TABLES', N'null', N'DBSERVER', N'Accounting', N'Accounting',
N'sp_MSsync_ins_PURGED_MGMT_TABLES_1',
N'sp_MSsync_upd_PURGED_MGMT_TABLES_1',
N'sp_MSsync_del_PURGED_MGMT_TABLES_1',
N'sp_MScft_Accounting_PURGED_MGMT_TABLES', N'dbo', N'null', N'null',
N'null',
0x00000010000000000000000000000000000000000000000000000000000000,
0,1,N'DBSERVER', 2 end
Transaction sequence number and command ID of last execution batch are
0x0001AA3A000001D500D800000001 and 81.

"Hilary Cotter" wrote:

It shouldn't be changing like this, can you post your schema or the
problem
table?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"archuleta37" <archuleta37@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F0B915F2-245D-4ECB-AC9D-CA5CA3D16AB6@xxxxxxxxxxxxxxxx
I'm working on setting up replication on a database in SQL 2000 and get
the
following error:

Implicit conversion from data type text to nvarchar is not allowed. Use
the
CONVERT function to run this query.
(Source: MYBACKUPSERVER (Data source); Error number: 257)

Why would this occur? I don't understand why a field datatype would
change
when doing replication. More importantly, I have no idea how to resolve
this
issue and research hasn't helped much. Can anyone give me some insight
on
where to start to fix this?






.

Relevant Pages

  • Re: datatype conversion error in sql 2000 replication
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... Implicit conversion from data type text to nvarchar is not ... (Source: MYBACKUPSERVER (Data source); Error number: 257) ...
    (microsoft.public.sqlserver.replication)
  • Re: datatype conversion error in sql 2000 replication
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... Implicit conversion from data type text to nvarchar is not allowed. ... (Source: MYBACKUPSERVER (Data source); Error number: 257) ...
    (microsoft.public.sqlserver.replication)
  • Re: datatype conversion error in sql 2000 replication
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Implicit conversion from data type text to nvarchar is not allowed. ... (Source: MYBACKUPSERVER (Data source); Error number: 257) ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication Error: "The Process could not enumerate changes at the Subscriber"
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.replication)
  • Re: non-updateable merge subscription
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... exactly the result that I want (changes go to subscriber but do not come ...
    (microsoft.public.sqlserver.replication)
Loading