Showing posts with label prompt. Show all posts
Showing posts with label prompt. 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

Command Prompt problems when installing MSDE

Hi,
I cannot seem to create a server instance when installing the MSDE.
step 1. I launch my cmd. It pops up with (C:\Documents and Settings\Billy
I type setup instancename="netsdk" sapwd="sa"
I immediately get a status message saying go to the control planel and
install and configure systems components. I am stuck here. If anyone can shed
some light with this problem I would appreciate it.
I am installing the MSDE onto my laptop(XP OS). I went to my control
panel->administrative tools->Local Security Policy-> but I don't what to look
for?
I am lost.
hi Billy,
Billy wrote:
> Hi,
> I cannot seem to create a server instance when installing the MSDE.
> step 1. I launch my cmd. It pops up with (C:\Documents and
> Settings\Billy
> I type setup instancename="netsdk" sapwd="sa"
> I immediately get a status message saying go to the control planel and
> install and configure systems components. I am stuck here. If anyone
> can shed some light with this problem I would appreciate it.
>
when opening the command prompt window, please navigate to the folder
containing the MSDE setup.exe boostrap installer, typically C:\MSDErelA\ or
C:\sql2kspX\MSDE\ (where X stands for the service pack level)...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
Forgive for not knowing, but how I do navigate to the root directory?
I tried the following commands you posted early,but cannot get to specified
location. The downloaded folder is under the C:\ dir. However, when my cmd is
invoked I cannot get to it from C:\Documents and Settings. One more time,
please. I even tried to copying the folder to the documents folder and still
no go.
Thanks
"Andrea Montanari" wrote:

> hi Billy,
> Billy wrote:
> when opening the command prompt window, please navigate to the folder
> containing the MSDE setup.exe boostrap installer, typically C:\MSDErelA\ or
> C:\sql2kspX\MSDE\ (where X stands for the service pack level)...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Andrea,
Recopied it to the Billy folder and create an instance to the server,
automatically starting installing. Error on my end. Thanks for the help.
"Billy" wrote:
[vbcol=seagreen]
> Andrea,
> Forgive for not knowing, but how I do navigate to the root directory?
> I tried the following commands you posted early,but cannot get to specified
> location. The downloaded folder is under the C:\ dir. However, when my cmd is
> invoked I cannot get to it from C:\Documents and Settings. One more time,
> please. I even tried to copying the folder to the documents folder and still
> no go.
> Thanks
> "Andrea Montanari" wrote:
|||Billy wrote:
> Andrea,
> Recopied it to the Billy folder and create an instance to the server,
> automatically starting installing. Error on my end. Thanks for the
> help.
?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Command Prompt

I apologize for asking a stupid question....I have Windows 2003 Server
installed, I am using SQL Server 2000 with all the sp's installed. I have
created db etc by utilizing the Enterprise Manager....I have been using a
SAMS book to learn some things however the very most basic rudimentary thing,
I have no clue.....
there are many examples that tell you to issue commands...where do I find
the command lines in SQL? Thanks for entertaining my humourous question...I
am not a programmer so I apologize in advance!!!
I can′t dtermine what you mean with command line, if you want the Dos (shell)
command line you can use XP_cmdshell and extended procedure to fire commadn
to the database, if you want to fire up some SQL commandsyou should head for
the Query Analyzer whcih is part as a client component of SQL Server or the
command line utility OSQL.exe which can be executed through the commadn line
in dos mode.
HTH, Jens Suessmeyer.
"SQL Brad" wrote:

> I apologize for asking a stupid question....I have Windows 2003 Server
> installed, I am using SQL Server 2000 with all the sp's installed. I have
> created db etc by utilizing the Enterprise Manager....I have been using a
> SAMS book to learn some things however the very most basic rudimentary thing,
> I have no clue.....
> there are many examples that tell you to issue commands...where do I find
> the command lines in SQL? Thanks for entertaining my humourous question...I
> am not a programmer so I apologize in advance!!!

Command Prompt

I apologize for asking a stupid question....I have Windows 2003 Server
installed, I am using SQL Server 2000 with all the sp's installed. I have
created db etc by utilizing the Enterprise Manager....I have been using a
SAMS book to learn some things however the very most basic rudimentary thing,
I have no clue.....
there are many examples that tell you to issue commands...where do I find
the command lines in SQL? Thanks for entertaining my humourous question...I
am not a programmer so I apologize in advance!!!I can´t dtermine what you mean with command line, if you want the Dos (shell)
command line you can use XP_cmdshell and extended procedure to fire commadn
to the database, if you want to fire up some SQL commandsyou should head for
the Query Analyzer whcih is part as a client component of SQL Server or the
command line utility OSQL.exe which can be executed through the commadn line
in dos mode.
HTH, Jens Suessmeyer.
"SQL Brad" wrote:
> I apologize for asking a stupid question....I have Windows 2003 Server
> installed, I am using SQL Server 2000 with all the sp's installed. I have
> created db etc by utilizing the Enterprise Manager....I have been using a
> SAMS book to learn some things however the very most basic rudimentary thing,
> I have no clue.....
> there are many examples that tell you to issue commands...where do I find
> the command lines in SQL? Thanks for entertaining my humourous question...I
> am not a programmer so I apologize in advance!!!

Command Prompt

I apologize for asking a stupid question....I have Windows 2003 Server
installed, I am using SQL Server 2000 with all the sp's installed. I have
created db etc by utilizing the Enterprise Manager....I have been using a
SAMS book to learn some things however the very most basic rudimentary thing
,
I have no clue.....
there are many examples that tell you to issue commands...where do I find
the command lines in SQL? Thanks for entertaining my humourous question...
I
am not a programmer so I apologize in advance!!!I can′t dtermine what you mean with command line, if you want the Dos (shel
l)
command line you can use XP_cmdshell and extended procedure to fire commadn
to the database, if you want to fire up some SQL commandsyou should head for
the Query Analyzer whcih is part as a client component of SQL Server or the
command line utility OSQL.exe which can be executed through the commadn line
in dos mode.
HTH, Jens Suessmeyer.
"SQL Brad" wrote:

> I apologize for asking a stupid question....I have Windows 2003 Server
> installed, I am using SQL Server 2000 with all the sp's installed. I have
> created db etc by utilizing the Enterprise Manager....I have been using a
> SAMS book to learn some things however the very most basic rudimentary thi
ng,
> I have no clue.....
> there are many examples that tell you to issue commands...where do I find
> the command lines in SQL? Thanks for entertaining my humourous question..
.I
> am not a programmer so I apologize in advance!!!

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