Hi,
How do I disable the "hand" icon right under the database icon in sql
enterprise manager?
ThanksThe "hand" indicates that the database is enabled for replication. If you
need replication, you cannot remove the hand. If you don't need
replication, look in BOL under "Replication". You will find numerous ways
to remove replication from specific articles all the way to removing it from
the server entirely. Come to think of it, look in BOL under "Replication"
either way. You will need to know about it if you intend to keep it.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:eh0A8CfIGHA.216@.TK2MSFTNGP15.phx.gbl...
> Hi,
> How do I disable the "hand" icon right under the database icon in sql
> enterprise manager?
> Thanks
>|||Go to Tools, Replication, Configure Publishers, Distributor, Subscribers,
and in the Publication databases, uncheck the check marks beside your
database which is being shared/replicated.
--
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
"mecn" <mecn2002@.yahoo.com> wrote in message
news:eh0A8CfIGHA.216@.TK2MSFTNGP15.phx.gbl...
> Hi,
> How do I disable the "hand" icon right under the database icon in sql
> enterprise manager?
> Thanks
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment