473,382 Members | 1,733 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,382 software developers and data experts.

How to customize view of SQL Server Enterprise Manager on startup?

Hi,

I've managed to get a couple of shortcuts on my desktop that log me
right into SQL Query Analyzer for whichever particular database I want
(using the isql.exe command line options). Now, I want to do a similar
customization for the SQL Server Enterprise Manager. I want to be able
to open SQL Server Enterprise Manager and have it pop me all the way
down into my particular database/tables view -> e.g. "Microsoft SQL
Servers\SQL Server Group\(LOCAL) (Windows
NT)\Databases\myDatabaseName". I'm hitting a local db server...

I've tried saving new consoles (.msc files), but that just doesn't seem
to do anything. I've tried using bookmarks, also, and they just don't
do anything at all when I select them.

Any ideas??

Jul 23 '05 #1
1 1463
On Dec 17 2004, 11:47 am, sh*****@lycos.co.uk wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:
I want to be able
to open SQL Server Enterprise Manager and have it pop me all the way
down into my particular database/tables view -> e.g. "Microsoft SQL
Servers\SQL Server Group\(LOCAL) (Windows
NT)\Databases\myDatabaseName".


The closest thing you can do is use Startup Options under Tools | Options |
Advanced. This will highlight the same node on startup that was highlighted
when you closed EM.

--
remove a 9 to reply by email
Jul 23 '05 #2

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

Similar topics

1
by: Bennett Haselton | last post by:
I want to get an ASP.Net hosting account with my ISP, and I'm trying to find out what level of access to the server is requried in order for me to view the server in Server Explorer in Visual...
3
by: David Gray | last post by:
Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003,...
2
by: R Bolling | last post by:
ver: SQL-DMO Version: 8.00.760 I have the option to automatically start SQL Server on startup, but when it does start up, the SQL Server Service Manager does not have the green arrow indicating...
3
by: wireless | last post by:
What is the best way to grant a user permission to create a view? I first created a role using enterprise manager but for the role I created it doesn't seem to offer that permission. It offers...
3
by: Thomas R. Hummel | last post by:
I am using SQL Server 2000, SP3. I created an updatable partitioned view awhile ago and it has been running smoothly for some time. The partition is on a DATETIME column and it is partitioned by...
1
by: mikew | last post by:
I am working at a company that has been using MS SQL Server, and we are going to be switching over to postgresql next week. (Getting off of Windows will be a relief!) I am very familiar with SQL...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
2
by: AH | last post by:
Dear all, I am facing this 'bug' that really drive me nut. I created a trigger for Update script and tested in Enterprise manager to ensure it function correctly. However, when I used both VB or...
1
by: mfanny | last post by:
Hi, We have SQL 7 running on Windows 2000 Server. For some reason we are unable to view Locks / Process ID from workstations running Windows XP SP2 with Enterprise Manager. Nothing shows up in...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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...

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.