Groups | Blog | Home
all groups > sql server replication > june 2006 >

sql server replication : Replication: "IsInstalled" registry value



ipramod NO[at]SPAM gmail.com
6/6/2006 10:48:41 PM
Hi,

I am facing a problem while monitoring the registry value that is set
when the replication is configured on the machine. When I newly
installed SQL Server 2000 using the default settings, the value of the
following registry value is always set to "1" even if the replication
is not configured.
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Replication\IsInstalled".
The "IsInstalled" key value says that it will be 0 (zero) when the
replication is not configured.

Can anyone let me know the solution for the above problem ASAP.

Thanks and Regards,
Pramod
Paul Ibison
6/7/2006 12:00:00 AM
Pramod,
is there any reason it needs to be done through the registry? I'm thinking
you could use sp_helpdistributor or
select name, databasepropertyex (name,'IsMergePublished') from
master..sysdatabases
select name, databasepropertyex (name,'IsPublished') from
master..sysdatabases


Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

ipramod NO[at]SPAM gmail.com
6/7/2006 3:57:09 AM
Hi Hilary,

Thanks for replying :-)

So is there anyway that I can get to know that replication is
configured on a machine through a registry key?

for example, I can get the AuditLevel of the SQL Server through a
following registry key
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\AuditLevel"

So is there any registry key present for Replication?

Let me know ASAP.

Thanks in advance,
Regards,
Pramod



[quoted text, click to view]
Hilary Cotter
6/7/2006 5:36:21 AM
I think this refers to the replication utilities when you run setup as
opposed to whether you have configured your server as a
publisher/distributor/subscriber.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]

ipramod NO[at]SPAM gmail.com
6/7/2006 6:42:37 AM
Hi Paul,

Actually my application checks the registry key and does some operation
based on that.
So, is there any way I can get the information of Replication is
configured or not?

Regards,
Pramod


[quoted text, click to view]
Paul Ibison
6/7/2006 3:44:44 PM
Hi Pramod - just did a comparison of the registry using notepad before and
after enabling replication and didn't find anything significant.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

ipramod NO[at]SPAM gmail.com
6/7/2006 10:49:11 PM
Hi Paul,

I observed the same things. So, is there any other way for the same?
for example, will there be any extra DLL gets installed or a process is
created or a service is installed or a file is placed on HDD?

Anyways thanks Paul.
Thanks for the information.

Regards,
Pramod


[quoted text, click to view]
Paul Ibison
6/8/2006 12:00:00 AM
Perhaps a dev will pick up the thread and confirm this for us. In your case
I'd query SQL Server and check there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

ipramod NO[at]SPAM gmail.com
6/8/2006 1:55:34 AM
Ok... Thanks Paul


[quoted text, click to view]
AddThis Social Bookmark Button