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.
sasi.k
Participant
1547 Points
296 Posts
Re: Creating a database in SQL Server using an SQL Script
May 29, 2008 05:07 AM|LINK
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>
Please remember to click "Mark as Answer" on this post if it helped you.