SQL Server Performance

replication problem

Discussion in 'Performance Tuning for SQL Server Replication' started by aspire, Oct 18, 2005.

  1. aspire New Member

    Hi All,

    I am trying to implement transactional replication on one of my semi critical server. The database size is around 1 GB. Everything looks fine till pubication and subscription is configured. But when snapshot is started it throws an error like "can not find datatype ''"
    Here ''contains some user defined data types.

    Problem looks like distributor is not able to move user defined data types to subscriber.

    Problem 2 :- The owner of the objects are being changed at the subscriber.

    Thanks in advance,
  2. suleman New Member

    can u please give the exact error with the error number and severity...

  3. [email protected] New Member

    Hi aspire

    Are you only replicating tables ?

    Have you tried copying/creating all user defined datatypes on the subscriber first ?

Share This Page