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 would be gratefully appreciated.

Thanks,
Tony

hi Tony,
Tony Girgenti wrote:
>
> 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. .....
>.....
> 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.
>

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 Andrea.

There is a warning that comes up when you try to add a new table
"Caution: New Database Features not Supported: You have connected to a
version of SQL Server later than SQL Server 2000. The version of Visual
Studio or Access that you are using was released before the version of SQL
Server to which you are connected. For this reason, you might encounter
problems."

That warning does not come up when i add a table to the SQL 2000 server.

I guess i should have realized the problem at that point.

Thanks,
Tony

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:4nv2tiFc0u58U1@individual.net...
> hi Tony,
> Tony Girgenti wrote:
>>
>> 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. .....
>>.....
>> 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.
>>
>
> 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
>