[2005] SQL server database creation pt 2

[leonreeet]

Please note that "SQL" is a language (Structured Query Language) and all grown-up databases use it. Even Access. If you're talking about Microsoft's database server then it is called "SQL Server", not just "SQL".

The standard method for us working class folks with VS 2005 is to install SQL Server on your development machine and use it to create an MDF file which you can then distribute with your app. You can get SQL Server 2005 Express for free from Microsoft and it integrates into all VS Versions. You'll then add an MDF database to your project and use VS to build the schema and, optionally, add data somewhat like you did in the Access application. Note that VS can be used to create MDB files in the same way.

oh ok i get ya.

so, how do i actually create the database after its installed.
my boss installed our sql server, and im pretty sure its sql server 2000.

theres no executional files of any sort in the install folder, only .ini's and files within folders that cant be opened.

I cant quite figure out how im supposed to create the database, with nothing to aid me after the install.

[Aspnot]

You would be best off to install Enterprise Manager somewhere where you can have access to it. Inside of Enterprise Manager, there is a wizard that will walk you through the creation of a database.

[leonreeet]

You would be best off to install Enterprise Manager somewhere where you can have access to it. Inside of Enterprise Manager, there is a wizard that will walk you through the creation of a database.

Whats the EXACT name of this program, cos i typed in enterprise manager into google, and it has like 10 different possible programs.

[Aspnot]

For SQL Server 2000, the exact name is Enterprise Manager. You won't find a download for it on the internet. You will need to install it from the SQL Server CDs.