Replication setup -- sql server replication

Hilary Cotter
10/3/2007 12:00:00 AM

Best way to check is to look in Enterprise Manager on the publisher and see
if any databases have hands under them. If so you have published databases.
Then you should expand these database and expand the publications folder and
click on the publications you find there. Then in the right hand pane see if
there are any entries which represent your subscribers.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
[quoted text, click to view]

sharman
10/3/2007 6:01:00 AM

Hi,

I am a newbie to replication. I recently joined a company where I have a SQL
Server running 2000 SP3 and I see a distribution database and Replication
Monitor in the Enterprise Manager.

On going to Tools->Replication ->Configure Publishing, Subscribers and
Distribution a pop-up window comes up. In this window under the Publishers
tab, the name of the Server comes up as selected. In the subscribers tab an
ODBC data source is selected. However, in the Publications database tab, NO
database name is checked.

I want to delete the distribution database. Can I safely assume that no
replication is taking place, since no database has been selected for
replication? Or is there a way to find out if any replication is taking

sql server replication : Replication setup