Re: (local) or computer name Enterprise Manager

From: Kimberly L. Tripp (Kimberly_PleaseReplyOnTheNewsGroups@nospam.sqlskills.com)
Date: 03/28/03 

From: "Kimberly L. Tripp" <Kimberly_PleaseReplyOnTheNewsGroups@nospam.sqlskills.com>
Date: Fri, 28 Mar 2003 10:55:57 -0800

This is probably just how the servers were "registered" within SQL
Enterprise Manager (EM). If you want - you can change the registration
properties... I'd change the EM settings for "local" to be the name of the
server by "deleting the registration" and then registering CANICHE.

Server "registration" is nothing exciting at all...it's JUST for the display
within Enterprise Manager.

hth,
kt

**** Please reply only on the newsgroups! Include dml/ddl, when possible.
Thanks ****
Kimberly L. Tripp
President, SYSolutions, Inc. www.SQLSkills.com
Principal Mentor, Solid Quality Learning www.SolidQualityLearning.com

"Cynthia Ayotte" <cynthia.ayotte.cgi@drdc-rddc.gc.ca> wrote in message
news:1048867298.962068@news.drenet.dnd.ca...
> I have a Sql server 2000 on a server windows 2000.
> When i am logging on specific user in the Enterprise Manager i saw the
Name
> of the server the computer name ex: CANICHE(Windows NT). And when i log
on
> with another user i saw (LOCAL) . I don't understand why ?
>
> The second user is Also Admistrator of the Domain.
> Excuse my English i am french Canadian.
>
>
>
>

Relevant Pages

  • REPOST:SQL Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... I had checked all the user rights, and everything seems to be proper...but ... running SQL 2000 Enterprise Edition on ... Windows 2000 Server. ... SQL Server on his Enterprise Manager using this SQL Login. ...
    (microsoft.public.sqlserver.security)
  • REPOST:SQL Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... I had checked all the user rights, and everything seems to be proper...but ... running SQL 2000 Enterprise Edition on ... Windows 2000 Server. ... SQL Server on his Enterprise Manager using this SQL Login. ...
    (microsoft.public.sqlserver.security)
  • Re: Enterprise Manager Locks Table
    ... Andrew J. Kelly SQL MVP ... > We have just moved a SQL Server database to a new server and since doing ... > viewed in Enterprise Manager until the table is closed. ... > the table is viewed using SQL Anaylser then the table lock does not remain ...
    (microsoft.public.sqlserver.tools)
  • Re: Enterprise Manager Locks Table
    ... > Andrew J. Kelly SQL MVP ... >> We have just moved a SQL Server database to a new server and since doing ... >> this I have found that a lock is placed on a table whenever it is being ... >> viewed in Enterprise Manager until the table is closed. ...
    (microsoft.public.sqlserver.tools)
  • Re: How to check if SQL 2000 is installed? (SBS 2003 SP1 Problem!)
    ... > Enterprise manager" and view the databases running on your server (just ... > click the + until you see databases), then you definitely have a SQL ... But I have sometimes installed two Tools called "MSDE Manager" and "MS SQL ...
    (microsoft.public.windows.server.sbs)