i've installed a SQL2008 trial version.

does anyone know how to create a database?

i clicked on the all SQL programs

no one looks like enterprise manager?

Thanks a lot.

tony

You can use SQLCMD to create a database. This (command prompt) tool is a
replacement of OSQL of SQL Server 2000.

SQL Server Management Studio is the replacement of the Enterprise Manager
and this new tool is appeared with SQL Server 2005 for the first time. This
management interface is not going to be installed by default, so you need to
explicitly select it to be installed during the SQL Server (2005 and 2008)
Setup. This is one of the Management Tools under Client Tools category.

To install SSMS after SQL Server 2008 RC0 installation, you need to rerun
SQL Server 2008 RC0 Setup. Choose your installed instance' s name during the
Setup and add this Management Tools feature to your installation.

There is another installation file named "x:\x86\Setup\sql_ssms.msi",
however it seems it does not work in this release. I think it's supposed to
install SSMS...

--
Ekrem Önsoy

thanks a lot.

it seems everything goes back Dos year, like exchange2007

"Ekrem

This is just because of security concerns, to reduce surface area attack.

You can install the management interface tool anytime you want as an
administrator.

--
Ekrem Önsoy

"Tony WONG" netvigator.com> wrote in message
news:%%23nwELAU8IHA.4608@TK2MSFTNGP06.phx.gbl...

i tried the management studio but the interface is completely out of my
knowledge.

is there any book for SQL 2008? Thanks.

"Ekrem

This interface is more familar with me
http://www.microsoft.com/global/sqlserver/2008/en/us/PublishingImages/scrn-policy...

But my interface only has running package and stored package

how to switch to microsoft one? thx.

"Tony WONG" netvigator.com>

Actually it seems you have your SSMS is installed but you are not connecting
to the Database Engine, you are connecting to Integration Services.

There is a Connect button in the Object Explorer in SSMS. When you click on
this Connect button, ensure you choose Database Engine from the drop down
menu. Then you'll be seeing a familar screen again.

Also, this Connect to Server dialog box appears automatically when you open
up SSMS. If you connected to Integration Services and close SSMS, then again
this service will be selected in the Server Type drop down list. Instead of
it, choose Database Engine and proceed.

--
Ekrem Önsoy

"Tony WONG" netvigator.com> wrote in message
news:Os1iSGW8IHA.3384@TK2MSFTNGP04.phx.gbl...

Thanks a lot.

"Ekrem