MSDE questions.

[Harry J]

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.

[oj]

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" <[e-mail]> 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.

[John Bell]

Hi

You may want to check out:
http://vyaskn.tripod.com/oracle_sql_...quivalents.htm
http://msdn.microsoft.com/library/de...oracle2sql.asp

John

"Harry J" <[e-mail]> 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.

[Pink Panther]

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" <[e-mail]> 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.