I have an SQL server Express edition Instance and I need to create a database on it but I don't have the Sql Browser how can I do it other wise
A:
hope these links can help you:
http://arcanecode.com/2007/01/26/create-a-table-in-sql-server-compact-edition-with-c/
anishmarokey
2010-10-11 11:42:49
A:
You can connect using "Server Explorer" in Visual studio (menu View, Server Explorer).
This window allows you to connect to an existing database (Sql2000, 2005, 2008, access).
Once you are able to connect you can:
- Use CREATE DATABASE commands
- (Best) Create a visual studio database project and use deployed script to create Database.
If you want you can setup database project to automatically deploy to a DB.
cad
2010-10-14 08:21:58
the question is to create a Database on a sql server 2005 and this is not available from server Explorer in visual studio
Mario
2010-10-14 08:24:31
You can connect to DB and later use Create database SQL command.. or better than this you could create a DB Project in visual studio and use its deploy script...
cad
2010-10-14 08:39:08
Edited my answer to include comment in it.
cad
2010-10-14 09:07:03