how to create our own database in sql server2005?

• ram-912425

  SSC Veteran

  Points: 287

  More actions

  November 21, 2008 at 10:26 pm

  #383440

  hi friends,

  i am new to this sql server2005.i don't know how to create our own database in sql server2005. i can't find out user databases like pubs and northwind.

  first i write

  create database [database_name]----> database created

  use [database_name]---->giving the following error.

  the error is: Could not locate entry in sysdatabases for database 'mydatabase'. No entry found with that name. Make sure that the name is entered correctly.

  if anybody knows please tell me.

  thanks in advance.

  cheers,

  ram.

• Lynn Pettis

  SSC Guru

  Points: 442447

  More actions

  November 21, 2008 at 11:46 pm

  #901977

  The sample databases pubs and NorthWind are gone. They were replaced with the AdventureWorks database.

  As for creating your own user databases, I'd start with reading Books Online and the CREATE DATABASE statement.

• Lynn Pettis

  SSC Guru

  Points: 442447

  More actions

  November 22, 2008 at 12:19 am

  #901988

  You probably tried to create and use the database at the same time. The CREATE DATABASE statement must be in its own batch. Try this:

  create database mytestdb

  go

  use mytestdb

  go