How to set loopback detection in SQL7

I am doing bi-directional replication between SQL2k and SQL7. How can I turn
loopback detection on? I have been looking for documentation and found
sp_replsetoriginator, but it doesn't talk about how it can be setup.
Thanks.
-A
You're probably not going to be able to do this. You can hardcode it though.
Add a column to each table with a default of @.@.servername. In the procs do
an existence check to see if the value of the servername column matches the
value of @.@.servername. If so don't do your DML as its looping back.
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
"Adam" <Adam@.discussions.microsoft.com> wrote in message
news:B0151D50-DD9D-4121-973D-49B6D4A5711C@.microsoft.com...
> I am doing bi-directional replication between SQL2k and SQL7. How can I
turn
> loopback detection on? I have been looking for documentation and found
> sp_replsetoriginator, but it doesn't talk about how it can be setup.
> Thanks.
> -A
>
|||Thank you so much.
"Hilary Cotter" wrote:

> You're probably not going to be able to do this. You can hardcode it though.
> Add a column to each table with a default of @.@.servername. In the procs do
> an existence check to see if the value of the servername column matches the
> value of @.@.servername. If so don't do your DML as its looping back.
> --
> 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
> "Adam" <Adam@.discussions.microsoft.com> wrote in message
> news:B0151D50-DD9D-4121-973D-49B6D4A5711C@.microsoft.com...
> turn
>
>