473,408 Members | 1,759 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Why two different views?

Hello all. I have an administrative account setup in Win XP Pro and I also
have a user account named "Jim Richards" (kinda logical, huh?). I previously
had to switch to the admin account to access the SQL Server Databases. Then
I gave myself admin privalidges to the SQL Server to the "Jim Richards"
account. I can now access SQL Server, update and change the database entries
(structure and data) from the "Jim Richards" account. But I get two
different views when I enter the Enterprise Manager and expand the Server
Group Line. Can anyone explain why I am getting two different views - one
which shows the Server name as "Local"

<a <a href="http://www.jimwrichards.com/images/JimRichardsView.gif">

JiJimRichardsView</a>

and the other which shows the Server name as "JIMRICHA" <a
href="http://www.jimwrichards.com/images/Admin24View.gif">Admin24View</a>?
Thanks in advance, Jim.
Jul 23 '05 #1
2 1292
Depends how you reqister the server with enterprise manager for the
account.
(local) is the default instance on the current machine.
If the machine is called JIMRICHA then they will access the same server.

You can get them to look the same by deleting one registration and
adding it again.

Nigel Rivett
www.mindsdoor.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 23 '05 #2
Thank you Erland Sommarskog and Nigel Rivett. I was able to delete the
registration that used the "LOCAL" name and I re-registered it with the
"JIMRICHA" name. Now both accounts use the same SQL Server name and I feel
much better. Again I thank you both. Jim

"Nigel Rivett" <sq***@hotmail.com> wrote in message
news:41********@127.0.0.1...
Depends how you reqister the server with enterprise manager for the
account.
(local) is the default instance on the current machine.
If the machine is called JIMRICHA then they will access the same server.

You can get them to look the same by deleting one registration and
adding it again.

Nigel Rivett
www.mindsdoor.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Mike N. | last post by:
Hello: I am new to T-SQL programing, and relativly new to SQL statements in general, although I have a good understanding of database theory. I'm a little confused as to the fundamental...
3
by: w | last post by:
Hello all!!! For a year and a half now, we have been developing different Access 2000 applications. Most of them are access frontend and access backends. Some of them have SQL server 2000 as a...
0
by: Jim Richards | last post by:
Hello all. I have an administrative account setup in Win XP Pro and I also have a user account named "Jim Richards" (kinda logical, huh?). I previously had to switch to the admin account to access...
3
by: KemperR | last post by:
Hello Experts outhere, may be someone can tell me whats going wrong with my ADOX trial. I have an Access 2002 database with some tables and queries (views) The code listed below works well up...
15
by: rod.weir | last post by:
Fellow database developers, I would like to draw on your experience with views. I have a database that includes many views. Sometimes, views contains other views, and those views in turn may...
9
by: serge | last post by:
/* Subject: How to build a procedure that returns different numbers of columns as a result based on a parameter. You can copy/paste this whole post in SQL Query Analyzer or Management Studio...
5
by: ahammad | last post by:
I have a split screen application with two panes. I would like to assign different views to each pane. I created the application using th wizard, which created a class called CSplitMFCView, a...
3
by: mayo | last post by:
just want to ask, is it possible to create views in which i will join tables from two different database? how?
3
by: Tej21 | last post by:
Hi all, Im creating a database in access for a fictional sports centre. What i would like help on is having different views for different logins. So, if i typed in the managers username and...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.