SQLServer 2005 Beta

[Peter Morris]

What's the deal with SQLServer 2005 Beta?

I've just got a magazine with a free cover disk with VB 2005 beta,
and also includes SQLServer 2005. I've installed it, but I can't get it
to do anything. It seems to have installed ok, there are the data files
for allthe usual system and example databases in place, and Task
Manager shows that SQLServer is definitely running. However the
only tool that came with it is called 'Computer Management' which
allows configuration options on the network, and to start and stop
SQL Server. There are none of the Enterprise Manager controls to
access the database, create tables, create users and so on. Enterprise
manager from SQL Server 2000 seems unable to detect the new
installation.

What's going on? Are there client tools I can download to access the
database with?

[Simon Hayes]

"Peter Morris" <dont_sp@m_me.com> wrote in message
news:TZ****************@text.news.blueyonder.co.uk ...

What's the deal with SQLServer 2005 Beta?

I've just got a magazine with a free cover disk with VB 2005 beta,
and also includes SQLServer 2005. I've installed it, but I can't get it
to do anything. It seems to have installed ok, there are the data files
for allthe usual system and example databases in place, and Task
Manager shows that SQLServer is definitely running. However the
only tool that came with it is called 'Computer Management' which
allows configuration options on the network, and to start and stop
SQL Server. There are none of the Enterprise Manager controls to
access the database, create tables, create users and so on. Enterprise
manager from SQL Server 2000 seems unable to detect the new
installation.

What's going on? Are there client tools I can download to access the
database with?

http://www.aspfaq.com/show.asp?id=2465
http://www.microsoft.com/downloads/d...displaylang=en

Assuming you have SQL Server Express 2005, then (as far as I know) there are
currently no client tools available except the command-line ones like
sqlcmd.exe.

Simon

[Damien]

"Peter Morris" <dont_sp@m_me.com> wrote in message news:<TZ****************@text.news.blueyonder.co.u k>...

What's the deal with SQLServer 2005 Beta?

I've just got a magazine with a free cover disk with VB 2005 beta,
and also includes SQLServer 2005. I've installed it, but I can't get it
to do anything. It seems to have installed ok, there are the data files
for allthe usual system and example databases in place, and Task
Manager shows that SQLServer is definitely running. However the
only tool that came with it is called 'Computer Management' which
allows configuration options on the network, and to start and stop
SQL Server. There are none of the Enterprise Manager controls to
access the database, create tables, create users and so on. Enterprise
manager from SQL Server 2000 seems unable to detect the new
installation.

What's going on? Are there client tools I can download to access the
database with?

If it SQL Server 2005 EXPRESS, then there aren't any other tools.
Anything you want to do with it (adding databases/tables, etc), you'll
have to do using transact SQL.

There are two command line SQL tools shipped with it. The recommended
one to use is SQLCMD.exe

[Peter Morris]

If it SQL Server 2005 EXPRESS, then there aren't any other tools.
Anything you want to do with it (adding databases/tables, etc), you'll
have to do using transact SQL.

There are two command line SQL tools shipped with it. The recommended
one to use is SQLCMD.exe

Okay, thanks for the info. Yes, its SQL Express.