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?
RegardsThe 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.com...
> 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
Friday, March 9, 2012
Enterprise Manager Icon
Labels:
database,
enterprise,
enterprisemanager,
icon,
infomation,
manager,
microsoft,
mysql,
oracle,
particular,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment