Wednesday, March 28, 2012

how to make new database sql server 2005!

i had no problems working whith sql server 2000
but whith 2005 i am unable to make new database!
question : HOW?
respond asap

You have two main options you can do it through the commad line tools sqlcmd (You should look at the books online, or run the sqlcmd /? for information on the syntax), Or you could install the sql server management tools for the SQL Express system. This is a free download that you can get from the MSDN Downloads site, or from the SQL Express home page on MSDN.

Of course if you do have the Visual Studio Express IDE's (any of them) Installed you can create database in them by using user instances. To do this go to your project and add a database file from the add item dialogs.

No comments:

Post a Comment