Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts

Tuesday, February 14, 2012

Command to start SQL Server Enterprise Manager

Hi,
Is there any command to start SQL Server Enterprise Manager from
the command prompt other than "SQL Server Enterprise Manager.MSC"
which cannot be called a short-cut.
Regards,
sasi.
Unless this IS an mmc snap-in there is no workaround for that. AFAIK
HTH, jens Suessmeyer.
|||sasiraj wrote on 20 Oct 2005 02:11:58 -0700:

> Is there any command to start SQL Server Enterprise Manager from
> the command prompt other than "SQL Server Enterprise Manager.MSC"
> which cannot be called a short-cut.
How about creating a batch file with a short name, and put
start "" "sql server enterprise manager.msc"
in it. The initial "" is there because start treats the first item as a
window title if it is enclosed in quotes, and you need to quote the msc
filename due to the spaces. This line will start EM and then the batch file
will immediately exit. Call it something like sqlem.cmd and put it somewhere
in your PATH (eg. c:\windows) and then you can run EM using just sqlem at
the command line.

Dan

Sunday, February 12, 2012

command line prompt to open sql server enterprise manager

Is there a command line prompt that will invoke SQL Server Enterprise
Manager, like 'isqlw' for Query Analyser?
I know that there used to be one for 6.5 to perform this.
Many thanks in advanceC:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"billu" <billu@.discussions.microsoft.com> wrote in message
news:E8719A48-FB22-4ED4-934C-5A2AB9D30636@.microsoft.com...
> Is there a command line prompt that will invoke SQL Server Enterprise
> Manager, like 'isqlw' for Query Analyser?
> I know that there used to be one for 6.5 to perform this.
> Many thanks in advance