Re: Turn off sharing to a database
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 06 Jun 2008 16:00:15 -0700
Hoardling1 via SQLMonster.com (u43783@uwe) writes:
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.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
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
.
- References:
- Turn off sharing to a database
- From: Hoardling1 via SQLMonster.com
- Turn off sharing to a database
- Prev by Date: Re: DDL LOGON event - Audit Logins
- Next by Date: Re: Protect MDF Only 1 user can access
- Previous by thread: Turn off sharing to a database
- Next by thread: Re: Turn off sharing to a database
- Index(es):
Relevant Pages
|
