I has problem to run EXEC in MSDE 8.00.760

I used the MSDE 8.00.760. I try to run EXEC from the command line, but it is
not recognized as a command ... I can run the osql in the command line. Does
someone knows what is the problem?
Thanks in advance.
hi,
LittlePlane wrote:
> I used the MSDE 8.00.760. I try to run EXEC from the command line,
> but it is not recognized as a command ... I can run the osql in the
> command line. Does someone knows what is the problem?
>
AFAIK, "EXEC" only is a Transact-SQL keyword that is of course not
recognized by the underlying OS but only from applications that can send it
to a SQL Server instance...
is it a particular application?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi, thanks, I am new with SQL. I know how to do it now.
"Andrea Montanari" wrote:

> hi,
> LittlePlane wrote:
> AFAIK, "EXEC" only is a Transact-SQL keyword that is of course not
> recognized by the underlying OS but only from applications that can send it
> to a SQL Server instance...
> is it a particular application?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

i cannot run express after i have installed it

my system meets the requirements and I have installed .net framework 2.0,

why can't i run sql express?

I tried running it from command prompt but nothing happens?

hi,

how did you "run" the SQLEXPR.EXE boostrap installer? please have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx for command prompt required and supported parameters...

as regards "system requirements", be sure they are satisfied as exposed in http://msdn2.microsoft.com/en-us/library/ms143680.aspx

and just to be sure () you can have a look at http://msdn2.microsoft.com/en-us/library/ms143441.aspx as well ...

regards

I believe I have installed SQLExpress ok but using the command prompt after that does not track

I am at the command prompt after installing SQLExpress and typing in the following: sqlcmd -S roger-xp-x2\SQLExpress -E and I get the following response: 1> and at that point I type in sp_grantlogin [roger-xp-x2\Roger and I get the following response: 2~ and not 2> I then type go and get a 3~ which I am guessing the tildes indicate errors. Any ideas where I am going amuck?

Roger

it looks like your missing a closing "]".|||

Thanks Dan, It only sounds too simple but I am hopefull that is all it is.

Roger