I have a sql 2005 publisher and distributor and a sql 2000 subscribers. for some reason on one of the subscribers i'm getting errors that it can't replicate the UDT's. i tried a new snapshot and made sure it was set not to replicate UDT's but i'm still getting Create Type errors.
would anyone have any idea why it's trying to create UDT's at the subscriber when i specify not to replicate UDT's?
Are you trying to exclude the UDT column, so it doesn't replicate to subscriber? How did you specify, so it does not replicate UDT? Did you add a vertical filter? Or?
Gary
|||in the article properties i left it on false for replicate user defined data types. it's UDT on the publisher and the base types on the subscribers.|||
I am not sure if this will solve your problem but you can try re-initializing your subscription before regenerating a new snapshot.
-Raymond
|||how many dba's does it take to change a light bulb?stupid mistake. need to change it to true to convert data types like on all our other publications
No comments:
Post a Comment