Friday, March 9, 2012

Enterprise Manager Icon

Hi,
I have just started using SQL server and am getting on fine with it,
however I cannot find any infomation on a particular Enterprise
Manager icon. Basically we have a number of databases, but I noticed
that the default Northwind database has a "small hand" - like a
Windows network share icon - displayed with it; what does this icon
mean? How can it be removed as none of the other databases display
this icon and are accessible in a multi-user environment?
Regards
The icon means that the database is enabled for replication. The
replication icons are documented in the SQL 2000 Bools Online
<replsql.chm::/repltools_8o6r.htm>.
If you have no replication publications or subscriptions for the Northwind
database, you can remove the 'publish' database option with
sp_replicationdboption:
EXEC sp_replicationdboption 'Northwind', 'publish', false
Hope this helps.
Dan Guzman
SQL Server MVP
"Zane" <zane_cahill@.hotmail.com> wrote in message
news:f27a37b7.0404041707.75c51f8@.posting.google.co m...
> Hi,
> I have just started using SQL server and am getting on fine with it,
> however I cannot find any infomation on a particular Enterprise
> Manager icon. Basically we have a number of databases, but I noticed
> that the default Northwind database has a "small hand" - like a
> Windows network share icon - displayed with it; what does this icon
> mean? How can it be removed as none of the other databases display
> this icon and are accessible in a multi-user environment?
> Regards

No comments:

Post a Comment