Transactional Replication Fails on a Table

Last Post 04 Dec 2008 09:01 AM by talltop. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
SQLUSA
New Member
New Member

--
03 Nov 2008 11:34 PM
All the tables made into articles at Publisher. All works OK except that one table (possibly the computed column is the problem).

The replication setup is just standard follow the wizards, nothing exotic.

When I remove the Customer article, everything working to perfection.

Kalman Toth
SQL Server 2008 Training - http://www.sqlusa.com/sql-server-2008-training

SQLUSA
New Member
New Member

--
08 Nov 2008 01:57 AM
That maybe the problem. Only replicated tables.

I will retest with udf replication included.

Kalman Toth
SQL Server 2008 Training -- http://www.sqlusa.com/order2008/


talltop
New Member
New Member

--
04 Dec 2008 09:01 AM
There is more than one computed column on that database, but that is the only one that calls a UDF, hence your error. I always use this query to quickly identify these troublesome little guys beforehand. Hope it helps. Travis.

SELECT 'table' = object_name(cl.id),'column name' = name, definition = text
FROM syscolumns cl JOIN syscomments cm
ON cl.id = cm.id
AND cm.number = cl.colid
WHERE iscomputed = 1




You are not authorized to post a reply.

Acceptable Use Policy