VB.NET Standard & SQL Server Desktop 1

[nigz]

I've in stalled the SQL server engine which comes with VB.Net Standard but how do I create a new database? I managed to create a create databse stored procedure in the master db and it appeared to run OK. However I can't see it - although if I try to run the sp again I get a message saying that the name is already in use???? Any pointers would be greatly appreciated. - N

 

[krisbrixon]

If you are refering to MSDE then there are no visual tools to manage the databases.

However, there are thrid party tools for that.

http://download.com.com/3120-20-0.html?qt=msde&tg=dl-2001

(I assume) most people do not develop with MSDE, but develop with SQL Server and then make the option for the end user as to which product they want to use. And since the end user will not be changing table formats it is not a big deal.

You received your error message since you ran the create statement twice and did not run a drop statement in between them. All it was saying is "hey I already have one of these!".

Take a look at the link called "SQL Query Tool" on the following page:

http://www.sourcecode.co.nz/index.htm

Kris





VS

 

[nigz]

Thanks Kris - I managed to create a db at last - will look at the tools you gave me links for. Thinking I might have a go at writing my own front end to server desktop.