Wednesday, July 9, 2008

Open Enterprise Manager using keyboard shortcut

To open enterprise manager in SQL Server 2000 using keyboard shortcut: Microsoft Management Console (MMC)
  • Start menu, Run, type "mmc"
  • In the file menu, recent file list select "SQL Server Enterprise Manager.msc"

If list is not there then try this one

  • Select Start - Run.
  • At the Open prompt enter: mmc
  • Click OK
  • Select File - Add/Remove Snap-in...
  • Click Add...
  • Select Microsoft SQL Enterprise Manager
  • Click Add, then Close
  • Click Ok to return to the mmc.
  • Select File - Save As...
  • Delete or rename the original (offending) file out the way.
  • Save the new msc file as C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC

or

  • In the start menu, Microsoft SQL Server, Enterprise Manager, right click on the menu, select properties
  • It will open properties for the shortcut
  • In the shortcut key, specify whatever shortcut key-combination you want.
For more information click here .

Use the technology!!!