<arfanameer@hotmail.com> wrote in message
news:1104123215.472796.136200@z14g2000cwz.googlegroups.com...
> How can I create a new database on sql server using OSQL command in
> command prompt. I have the sql file for database creation and I use the
> following command
>
> C:\> osql -S servername -U sa -i db1.sql
> it prompt my for password n i enter it since sa has a blank password
> but after that it returns the following error.
>
> 1> 2> 3> Msg 170, Level 15, State 1, Server servername, Procedure ,
> Line 2
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
> syntax near 'COLLATE'.
> 1> 2> 3> Msg 15010, Level 16, State 1, Server servername, Procedure
> sp_dboption, Line 95
> [Microsoft][ODBC SQL Server Driver][SQL Server]The database
> 'db1' does not exist. Use sp_helpdb to show available databases
> Can anyone help me on that?
>

> How can I create a new database on sql server using OSQL command in
> command prompt. I have the sql file for database creation and I use the
> following command
>
> C:\> osql -S servername -U sa -i db1.sql
> it prompt my for password n i enter it since sa has a blank password

> but after that it returns the following error.
>
> 1> 2> 3> Msg 170, Level 15, State 1, Server servername, Procedure ,
> Line 2
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
> syntax near 'COLLATE'.
> 1> 2> 3> Msg 15010, Level 16, State 1, Server servername, Procedure
> sp_dboption, Line 95
> [Microsoft][ODBC SQL Server Driver][SQL Server]The database
> 'db1' does not exist. Use sp_helpdb to show available databases
> Can anyone help me on that?

>How can I create a new database on sql server using OSQL command in
>command prompt. I have the sql file for database creation and I use the
>following command
>
>C:\> osql -S servername -U sa -i db1.sql
>it prompt my for password n i enter it since sa has a blank password
>but after that it returns the following error.
>
>1> 2> 3> Msg 170, Level 15, State 1, Server servername, Procedure ,
>Line 2
>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
>syntax near 'COLLATE'.
>1> 2> 3> Msg 15010, Level 16, State 1, Server servername, Procedure
>sp_dboption, Line 95
>[Microsoft][ODBC SQL Server Driver][SQL Server]The database
>'db1' does not exist. Use sp_helpdb to show available databases
>Can anyone help me on that?
>
>
>
>
>
>
>