0

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

skaffman
  • 398,947
  • 96
  • 818
  • 769
Mario
  • 167
  • 1
  • 6
  • 17
  • 1
    Do you mean SQL Management studio? The SQL Browser is a background service unrelated to what you are asking. – leppie Oct 11 '10 at 11:33

2 Answers2

1

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.

Oscar Foley
  • 6,817
  • 8
  • 57
  • 90
  • the question is to create a Database on a sql server 2005 and this is not available from server Explorer in visual studio – Mario Oct 14 '10 at 08:24
  • 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... – Oscar Foley Oct 14 '10 at 08:39
  • Edited my answer to include comment in it. – Oscar Foley Oct 14 '10 at 09:07
-1

hope these links can help you:

http://arcanecode.com/2007/01/26/create-a-table-in-sql-server-compact-edition-with-c/

http://www.c-sharpcorner.com/UploadFile/mahesh/CreatingDBProgrammaticallyMCB11282005064852AM/CreatingDBProgrammaticallyMCB.aspx

anishMarokey
  • 11,279
  • 2
  • 34
  • 47