From: Stefan on
Hi Ben!

I created the publication with the assistant, however we saved all the
scripts the assistant used and the @schema_option parameter was
"0x0000000030034FF1".
0x20 was set I guess, am I wrong?

Because of some other problems we decided to upgrade the subscriber to
SQL Server 2005, so everything is fine now.

Thank you very much for your help!

Stefan


Ben Thul schrieb:
> Do you have the invocation of sp_addarticle that you used? If so,
> check out the @schema_option parameter. Specifically, if bit 0x20 is
> set. According to BOL, this will tell replication to convert user-
> defined types to their base types at the subscriber. That should do
> the trick.
> --
> HTH,
> Ben