Newbie question on meaning of icon...

Hi! I have "inherited" a SQL server that I am quickly trying to get up to
speed on administering. There are several db's on the server. If I look at
the db's in enterprise manager one of them has what looks to be a "shared"
icon beside the db name. It looks just like the other db icons but has that
"share" hand underneath. What does this symbolize and how do I make
adjustments to this setting.
Sorry for being so obtuse! Thanks for the help!
-alex-
The 'sharing' hand means the database has been enabled for replication.
First, you read BOL (Books On-Line) and understand what replication is and
hw it works before you make any adjustments.
IMHO, your first concern should be backup and recovery. Next comes
space/performance management and monitoring. Last comes changes and
improvements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bairda" <bairda@.discussions.microsoft.com> wrote in message
news:F5139783-2191-442A-9584-04C743848493@.microsoft.com...
> Hi! I have "inherited" a SQL server that I am quickly trying to get up to
> speed on administering. There are several db's on the server. If I look
at
> the db's in enterprise manager one of them has what looks to be a "shared"
> icon beside the db name. It looks just like the other db icons but has
that
> "share" hand underneath. What does this symbolize and how do I make
> adjustments to this setting.
> Sorry for being so obtuse! Thanks for the help!
> -alex-

Newbie question on meaning of icon...

Hi! I have "inherited" a SQL server that I am quickly trying to get up to
speed on administering. There are several db's on the server. If I look at
the db's in enterprise manager one of them has what looks to be a "shared"
icon beside the db name. It looks just like the other db icons but has that
"share" hand underneath. What does this symbolize and how do I make
adjustments to this setting.
Sorry for being so obtuse! Thanks for the help!
-alex-The 'sharing' hand means the database has been enabled for replication.
First, you read BOL (Books On-Line) and understand what replication is and
hw it works before you make any adjustments.
IMHO, your first concern should be backup and recovery. Next comes
space/performance management and monitoring. Last comes changes and
improvements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bairda" <bairda@.discussions.microsoft.com> wrote in message
news:F5139783-2191-442A-9584-04C743848493@.microsoft.com...
> Hi! I have "inherited" a SQL server that I am quickly trying to get up to
> speed on administering. There are several db's on the server. If I look
at
> the db's in enterprise manager one of them has what looks to be a "shared"
> icon beside the db name. It looks just like the other db icons but has
that
> "share" hand underneath. What does this symbolize and how do I make
> adjustments to this setting.
> Sorry for being so obtuse! Thanks for the help!
> -alex-

Newbie question on meaning of icon...

Hi! I have "inherited" a SQL server that I am quickly trying to get up to
speed on administering. There are several db's on the server. If I look at
the db's in enterprise manager one of them has what looks to be a "shared"
icon beside the db name. It looks just like the other db icons but has that
"share" hand underneath. What does this symbolize and how do I make
adjustments to this setting.
Sorry for being so obtuse! Thanks for the help!
-alex-The 'sharing' hand means the database has been enabled for replication.
First, you read BOL (Books On-Line) and understand what replication is and
hw it works before you make any adjustments.
IMHO, your first concern should be backup and recovery. Next comes
space/performance management and monitoring. Last comes changes and
improvements.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bairda" <bairda@.discussions.microsoft.com> wrote in message
news:F5139783-2191-442A-9584-04C743848493@.microsoft.com...
> Hi! I have "inherited" a SQL server that I am quickly trying to get up to
> speed on administering. There are several db's on the server. If I look
at
> the db's in enterprise manager one of them has what looks to be a "shared"
> icon beside the db name. It looks just like the other db icons but has
that
> "share" hand underneath. What does this symbolize and how do I make
> adjustments to this setting.
> Sorry for being so obtuse! Thanks for the help!
> -alex-

Newbie Q setting up MSDE

Hello. I've installed MSDE (Win2k machine, running asp.net on localhost),
and it says 'Not Connected' when I mouseover the icon in the system tray. I
opened the SQL Server service manager, and there are two empty fields-
Server and Services. Please, what do I put in these fields? Also, what
connection string would I use with MSDE. Thanks a lot
Justin Dutoit
hi Justin,
"Justin Dutoit" <anon@.anon.com> ha scritto nel messaggio
news:%23Gr48BqqEHA.3988@.tk2msftngp13.phx.gbl
> Hello. I've installed MSDE (Win2k machine, running asp.net on
> localhost), and it says 'Not Connected' when I mouseover the icon in
> the system tray. I opened the SQL Server service manager, and there
> are two empty fields- Server and Services. Please, what do I put in
> these fields? Also, what connection string would I use with MSDE.
> Thanks a lot
> Justin Dutoit
please verify, using the services applet (control panel->performance and
maintenance->administrative tools->services [on XP] , control
panel->administrative tools->services [on Win2k]) that your MSDE instance is
currently up and running...
you can then try typing in the service name of your MSDE instance to manage
it...
MSDE installs by default disabling network protocols and this can be an
issue for some ODBC related functions and, sometime, the SQL Server
instances are not enlisted by the Service Manager, as reported in
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply