Creating a database in SQL Server using an SQL Script

Hi,

I am trying to create the "Personal" database in my SQL server using the SQL script (Personal.sql) that is provided with the starter kit. Does anyone know how I can run this script to create the database? Do I do it from the command line? If so how do I do this and can I use windows authentication to connect to the server?

Many thanks in advance,

Trevor Keast

Re: Creating a database in SQL Server using an SQL Script

Hi,

We can run the scripts in two ways.

1. Open your Sql client , if it is sql server 2005 then sql management studio Run-->sqlwb,Sql server 2000 then isqlw. Login to your database server using either sql authentication or windows authentications what ever you want. if you are having create database script in your personal.sql then , just copy the script file content and paste in query window and run it,

it will create the personal database.

2. The Alternate way is Running from comman line ,you need to run OSQL command for achieving this one.

the OSQL synatax is

OSQL -U <user name> -P <Password> -S <SQl Server Name> -i <Script File Path>