|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Friday, November 26, 2010 10:50 PM
Points: 10,
Visits: 19
|
|
Hi All, I am using Sql server 2000. I am not able to see Enterprise manager through:
start=>program=>Microsoft Sql Server
I have created a shortcut on desktop, through mmc console. But I want enterprise manager to be viewed in program list. Please suggest as this is a production server.
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 11,791,
Visits: 28,075
|
|
click start, and when programs button is visible, right click on it; "Open" is the first choice, click that. a folder opens, drill down inside the Programs folder to where you want Enterprise Manager to appear, and drag a copy of your desktop shortcut to that spot (right click the icon...drag..when you let go...select copy shortcut)
Lowell
--There is no spoon, and there's no default ORDER BY in sql server either. Actually, Common Sense is so rare, it should be considered a Superpower. --my son
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Friday, November 26, 2010 10:50 PM
Points: 10,
Visits: 19
|
|
thanks for quick help. i did as u said, but its not even showing the sql server folder where i can drag down the enterprise manager option. plz help.
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Tuesday, June 04, 2013 4:09 AM
Points: 1,618,
Visits: 20,904
|
|
To add to what Lowell has mentioned, copy that shortcut to the below folder. Since you don't have "Microsoft SQL Server" folder create it manually before copying the shortcut. This ensures that the Enterprise Manager shortcut is visible to all the users logging on to the server.
C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft SQL Server
Pradeep Adiga Blog: sqldbadiaries.com Twitter: @pradeepadiga
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 11,791,
Visits: 28,075
|
|
snehagupte (10/27/2010) thanks for quick help. i did as u said, but its not even showing the sql server folder where i can drag down the enterprise manager option. plz help.
simply right click inside the Programs folder you opened and click New...folder rename it to "Microsoft SQL Server" then put your shortcuts in side that. while you are there, you probably want to put a shortcut to Query Analyzer in there too.
Lowell
--There is no spoon, and there's no default ORDER BY in sql server either. Actually, Common Sense is so rare, it should be considered a Superpower. --my son
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Friday, November 26, 2010 10:50 PM
Points: 10,
Visits: 19
|
|
Thanks you so much Lowell and Pradeep.
I used 1st suggestion by Lowell and Pradeep refined it. Now by applying both of the solutions, i got enterprise manager in my program list.
Thanks a ton for helping me out with so fast response.
|
|
|
|