replicating UDT's to subscribers

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

Replicating twice

I have a question that google seems eerily quite on. I'm running SQL
2005 and am replicating (merge via the web) from an intermediate box
which is also running 05. The intermediate box is replicating in some
fashion (unsure since it isn't under my control) from a SQL 2K box.
My issue is that when the job executes it says "Merge completed with no
data changes processed." even though the intermediate box has updated
data on it. Is this common? Is the answer so obvious that everyone is
laughing at me now?
Thanks
Jeremiah
It should work. How is your global priority configured? You might want to
check the conflict viewer to see if these conflicts are logged.
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
"JC" <jbzcooper@.gmail.com> wrote in message
news:1141343267.632060.296050@.u72g2000cwu.googlegr oups.com...
>I have a question that google seems eerily quite on. I'm running SQL
> 2005 and am replicating (merge via the web) from an intermediate box
> which is also running 05. The intermediate box is replicating in some
> fashion (unsure since it isn't under my control) from a SQL 2K box.
> My issue is that when the job executes it says "Merge completed with no
> data changes processed." even though the intermediate box has updated
> data on it. Is this common? Is the answer so obvious that everyone is
> laughing at me now?
> Thanks
> Jeremiah
>
|||Jeremiah,
If I understand correctly, your SQL 2005 is subscribing from an intermediate
box, which subscribes from a SQL 2K server? Please note that for merge
replication, the publisher database version has be to newer than the
subscriber version, so basically SQL Server 2005 cannot be a subscriber of a
SQL 2000 publisher.
Yi Chen
"JC" <jbzcooper@.gmail.com> wrote in message
news:1141343267.632060.296050@.u72g2000cwu.googlegr oups.com...
>I have a question that google seems eerily quite on. I'm running SQL
> 2005 and am replicating (merge via the web) from an intermediate box
> which is also running 05. The intermediate box is replicating in some
> fashion (unsure since it isn't under my control) from a SQL 2K box.
> My issue is that when the job executes it says "Merge completed with no
> data changes processed." even though the intermediate box has updated
> data on it. Is this common? Is the answer so obvious that everyone is
> laughing at me now?
> Thanks
> Jeremiah
>
|||Are there any filters on the publisher that make the data not qualify for
the subscriber?
Hope that helps
--Mahesh
[ This posting is provided "as is" with no warranties and confers no
rights. ]
"JC" <jbzcooper@.gmail.com> wrote in message
news:1141343267.632060.296050@.u72g2000cwu.googlegr oups.com...
> I have a question that google seems eerily quite on. I'm running SQL
> 2005 and am replicating (merge via the web) from an intermediate box
> which is also running 05. The intermediate box is replicating in some
> fashion (unsure since it isn't under my control) from a SQL 2K box.
> My issue is that when the job executes it says "Merge completed with no
> data changes processed." even though the intermediate box has updated
> data on it. Is this common? Is the answer so obvious that everyone is
> laughing at me now?
> Thanks
> Jeremiah
>

Replicating to SSCE tables with "create statistics" doesn't works: how to avoid

When merge replicating SQL Server tables with created Statistics, the SSCE
subscription to that table fails. To avoid this problem I manually deleted
the lines with CREATE STATISTICS statements from the *.dri archives that
contains the script for index creation on the snapshot. The *.dri archives
are generated by the Snapshot Agent and uploaded into the IIS that acts as a
replication gateway between SS and SSCE.
My concerns are how safe is doing this?
It's highly recommended in SS to enable statistics for tables. Our database
without them turns to be too slowly. On the other hand when enabling
statistics we can't synchronize with SSCE users. Then this incompatibility
with SSCE when replicating is highly restrictive for the usability of SSCE.
Why it isn't an "official" solution to this problem, when the solution looks
to be so simple? Or may be it is not so simple...
Any comments will be highly appreciated
Thanks in advance
Faustino Dina
If my email address starts with two 'f'
drop the first 'f' when mailing me.
Faustino,
you could use sp_addscriptexec with the SkipError bit set to 1.
This will enable you to apply the create statistics command to all
subscribers regardless of the edition they have.
HTH,
Paul Ibison

Replicating to SQL 2000/2005 Express

We would like to replicate from SQL 2000/2005 Enterprise Edition to its
Express version and wanted to know if there we any issues around it. This
would be transactional replication
Hassan,
the main distinction that I know of is that for pull subscriptions there is
the limitation of Windows Synchronization Manager or RMO. Also obviously
there can be no republishing.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Replicating to over 70 databases...why??

Is this reasonable or is this poor design...why not just a few power servers
and all users have high speed internet connections or at least DSL'
Thanks
Ken S.Think you will have to explain your situation a little more to get any good
feedback
Ray Higdon MCSE, MCDBA, CCNA
--
"SMAN" <ksanti@.nycap.rr.com> wrote in message
news:O1ct4n9AEHA.2404@.TK2MSFTNGP11.phx.gbl...
> Is this reasonable or is this poor design...why not just a few power
servers
> and all users have high speed internet connections or at least DSL'
> Thanks
> Ken S.
>

Replicating to over 70 databases...why??

Is this reasonable or is this poor design...why not just a few power servers
and all users have high speed internet connections or at least DSL'
Thanks
Ken S.Think you will have to explain your situation a little more to get any good
feedback
--
Ray Higdon MCSE, MCDBA, CCNA
--
"SMAN" <ksanti@.nycap.rr.com> wrote in message
news:O1ct4n9AEHA.2404@.TK2MSFTNGP11.phx.gbl...
> Is this reasonable or is this poor design...why not just a few power
servers
> and all users have high speed internet connections or at least DSL'
> Thanks
> Ken S.
>

Replicating to MYSQL

I have been trying to replicate from SQL2K to MySQL and I'm getting an
'Invalid Cursor State' error. After looking around for a solution I
found this old message (http://tinyurl.com/2mb5ln) saying it was a bug
in the distribution agent code and it would be fixed in future service
packs.
Was this ever solved?
My understanding is that they did not.
Hilary Cotter
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
"Fawzib Rojas" <f_rojas@.nospam.spectron.msim.com> wrote in message
news:OHG1g0hdHHA.4468@.TK2MSFTNGP03.phx.gbl...
>I have been trying to replicate from SQL2K to MySQL and I'm getting an
>'Invalid Cursor State' error. After looking around for a solution I found
>this old message (http://tinyurl.com/2mb5ln) saying it was a bug in the
>distribution agent code and it would be fixed in future service packs.
> Was this ever solved?