MSDE questions.

Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
in from an Oracle background). I have installed it and have a couple of
questions.

1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
where you can log on to the database and view tables/data/views and so on?

2.) I need to set up an account with a username/password. Is there a
executable that I require to be able to perform this task?

3.) I see Enterprise manager on microsoft website, but is that shipped with
MSDE?

I know that these may sound simple, but I would appreciate your comments.

Kind regards,

Harry.Harry,

MSDE comes with Osql command line utility that you can use to interact with your
server. Unfortunately, MSDE does not come with any UI tool.

Andrea has done a great job at getting a free UI tool for you. You can get more
info at http://www.asql.biz/DbaMgr.shtm
If you're already familiar with T-SQL, you can use our free tool, QALite from
site.

--
-oj
http://www.rac4sql.net

"Harry J" <xx@.yy.com> wrote in message news:5B6Lb.20979$ts4.2084@.pd7tw3no...
> Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
> 1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
> where you can log on to the database and view tables/data/views and so on?
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
> 3.) I see Enterprise manager on microsoft website, but is that shipped with
> MSDE?
> I know that these may sound simple, but I would appreciate your comments.
> Kind regards,
> Harry.|||Hi

You may want to check out:
http://vyaskn.tripod.com/oracle_sql...equivalents.htm
http://msdn.microsoft.com/library/d.../oracle2sql.asp

John

"Harry J" <xx@.yy.com> wrote in message news:5B6Lb.20979$ts4.2084@.pd7tw3no...
> Hello, I am new to MS SQL database and have recently downloaded MSDE
(Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
> 1.) Is there a product something like SQLPLUS (hopefully shipped with
MSDE)
> where you can log on to the database and view tables/data/views and so on?
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
> 3.) I see Enterprise manager on microsoft website, but is that shipped
with
> MSDE?
> I know that these may sound simple, but I would appreciate your comments.
> Kind regards,
> Harry.|||Hi Harry,

I see that TOAD now comes with a freeware version for SQL Server. I
haven't tried it, but I presume you could use it to connect to MSDE.

Coming from an Oracle background you may have used TOAD before so it
could give you a leg up.

http://toadsoft.com

Peter

"Harry J" <xx@.yy.com> wrote in message news:<5B6Lb.20979$ts4.2084@.pd7tw3no>...
> Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
> 1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
> where you can log on to the database and view tables/data/views and so on?
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
> 3.) I see Enterprise manager on microsoft website, but is that shipped with
> MSDE?
> I know that these may sound simple, but I would appreciate your comments.
> Kind regards,
> Harry.