Creating database

I have been using microsoft office access to create database and connect to application built. This is the first time trying to create database using the sql server. How do i create a database using this?

Do i use the sql server management to create it?

Is there any step by step tutorials?

How do i connect the database to the web developer?

For creating a database, look in the BOL. There are several option for creating a database. The most easy one would be use the SQL Server Management Studio, right clicking on the database node > New database, after specifying the name and the properties of the database like collation / storage destination etc. the database will be created. Another option would be to use TSQL commands (BOL will have more information about the syntax and parameters for you). Connecting with the Web developer is quite easy, as you can select the database in the server explorer after connecting to the database server.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi thanks for the help.

I am trying to built a web database using the visual studio web developer 2005 express. client will be able to access the database in the intranet server. I found out that i can built a database using the web developer itself so what is the different from built it using the sql server?

|||

takkyangel wrote:

I have been using microsoft office access to create database and connect to application built. This is the first time trying to create database using the sql server. How do i create a database using this?

Do i use the sql server management to create it?

Is there any step by step tutorials?

How do i connect the database to the web developer?

Have you checked out http://www.LearnSqlServer.com? There's a whole section with step-by-step tutorials on creating/managing databases:
Database Creation, Management and Best Practices - http://www.learnsqlserver.com/VideoTutorials/Sql-Server-Videos/93/Database-Creation-Management-and-Best-Practices.aspx?an=MsdnForums