sql server replication: can this b done by replication ? -- sql server replication

can this b done by replication ?

San
12/7/2004 10:30:58 AM

sql server replication:

hi all,

I have a single sql server, and two databases with similar
table names and structures for some 10-15 tables.

I want replicate the data from one db to another to keep
them in sync.

Can I do this using replication ?
Is replication possible between two db's of a single
server ?
I tried already it gives an error 18483 could not connect
to server cause distributor_admin is not defined as a
remote login at the server ???

Re: can this b done by replication ?

Hilary Cotter
12/7/2004 2:08:02 PM

You can replicate to the same server. TO fix your distributor_admin problem
disable replication and re enable it.

This normally fixes this problem.

--
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html

[quoted text, click to view]