The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
Home SS SLUG Forums Articles Photos Downloads
A Merry Christmas
and a
Happy
New Year

to all...

Transactional Replication with updatable subscribers

  •  07-19-2007, 3:53

    Transactional Replication with updatable subscribers

    hi,

    I created a publisher of type, 'Transactional replication with updatable subscribers' and also created a subscriber

    both pubslisher and the subscriber is in the same server

    After the snapshot been applied at the subscriber, I could do the changes at the subscriber and the changes are correctly at the publisher, But the broblem came when I tried to update the published table. When I tried to change data item in the table at the publisher the following error comes. This happenes only to this type of replication. All other replicatoin types work fine.

    Error:  Maximum stored procedure, function, trigger , or view nesting level exceeded (limit32)

    dunno whats the reason for this

    cheers!

    Supun

     

View Complete Thread

(Best viewed with a resolution of more than 1024 * 768)

Powered by Community Server, by Telligent Systems