Turn off sharing to a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hoardling1 - 06 Jun 2008 16:18 GMT

How do you turn off the sharing to a SQL Server 2000 database. I want to
remove the symbol of the hand holding the database(yellow cylinder) when I
view my databases. I can't find the option. So I am mainly looking at how
to get to that option.

Reply to this Message

Erland Sommarskog - 07 Jun 2008 00:00 GMT

> How do you turn off the sharing to a SQL Server 2000 database. I want
> to remove the symbol of the hand holding the database(yellow cylinder)
> when I view my databases. I can't find the option. So I am mainly
> looking at how to get to that option.

That's not a sharing icon, but something else. I don't know what, though.
Can you run sp_helpdb on that datbase and post the output? That should
probably reveal which option that is in force.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message

Dan Guzman - 08 Jun 2008 18:21 GMT

I believe the database hand icon indicates the database is published for
replication. You'll need to use the replication tools/procs to remove
replication if that's your goal.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

> How do you turn off the sharing to a SQL Server 2000 database. I want to
> remove the symbol of the hand holding the database(yellow cylinder) when I
> view my databases. I can't find the option. So I am mainly looking at
> how
> to get to that option.

Reply to this Message

Hoardling1 - 14 Jul 2008 20:15 GMT

Found the answer in another question someone asked.
It is part of replication.
To remove it when you don't need replication anymore.
Go to Tools>Replication>Configure Publishing Subscribers and distribution> go
to tab Publication Databases> and uncheck the Databases you want to remove it
from.

>I believe the database hand icon indicates the database is published for
>replication. You'll need to use the replication tools/procs to remove
[quoted text clipped - 5 lines]
>> how
>> to get to that option.

Reply to this Message