sql server new users: hi Tony,
[quoted text, click to view]

the VS 2003 are not completely compatible with SQL Server 2005 metadata...
AFAIK, you should use SQL Server Management Studio Express to perform that
kind of tasks..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
--------- remove DMO to reply

Hello.

I don't understand the SQL Databases.

I was once using MSDE of SQL2000(Server name = DHJC2R91). Since playing
with VWD, i downloaded and installed SQL Server 2005 Express Edition(It gave
me a server name of DHJC2R91\SQLEXPRESS). After that when i use the systray
icon with the little green arrow, it showed both servers.

I'm using VS.NET 2003. When i open the Server Explorer, i can see both
servers(DHJC2R91 and DHJC2R91\SQLEXPRESS), but when i add a new database to
the DHJC2R91\SQLEXPRESS server and then try to add a table to it, it lets me
create the table in the Database Design screen, but after i save it and
close it, it's gone. It just dissappears and does not show up under the
database that i added. If i do the same thing with DHJC2R91 server, it
works OK. The table gets saved.

When i look at the properties for each of the servers in Server Explorer,
the type for both servers says SQL Server 2000 Database. It also has the
same type for each of the databases under both servers.

When i look at the properties for each of the servers in Microsoft SQL
Server Management Studio Express, DHJC2R91 shows a version of 8.00.760,
Product of Microsoft SQL Server Desktop Engine and a Root Directory of
C:\Program Files\Microsoft SQL Server\MSSQL. DHJC2R91\SQLEXPRESS shows a
version of 9.00.2047.00, Product of Microsoft SQL Server Express Edition and
a Root Directory of C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL.

Does anybody know why i can't add tables to the DHJC2R91\SQLEXPRESS server ?
I can add a database, but not any tables.

I can add a new database and tables to DHJC2R91\SQLEXPRESS server using
Microsoft SQL Server Management Studio Express.

Also, can anyone offer any insight as to whether i have these servers set up
right. Should i have two servers ?

Any help would be gratefully appreciated.

Thanks,
Tony