473,397 Members | 2,084 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,397 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 1291
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
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.