Hi
I create a database in SQL Express using the Microsoft SQL Server Management Studio Express, with tables etc.
I connect to it from my VB Express .NET application. Any changes I make, like adding a new table from VB .NET Express causes all the tables to 'vanish' when viewing the Database in the Microsoft SQL Server Management Studio Express, the database is still listed there. Does anyone know why
Also it cannot be edited there again it gives an error
Also if I create a DB in VB .NET Express the database does not appear in the Microsoft SQL Server Management Studio Express, which makes backups etc not available. It is saved to a drive location, but not the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data location, any ideas what is happening
Regards.
Larry_t
Database tables, views, security etc vanishing.
Thomas Danecker
Hi Larry,
The issue is that you are actually working with multiple database files here. SQL Express allows you to connect to an .mdf file like a regular SQL database and when you point off to the database in VB Express, it actually makes a copy and puts it in the project folder. At that point you are working on your project database and not on the original one.
A dev on our team has written a good blog on getting started understanding the SSE/VB functionality at: http://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx
Hope it helps,
Eric Gruber
Visual Basic Team
TACSY
Thanks.
Will look into this, it is just very annoying that you cannot use the tools in SQL Express to further work on the DB design.