OSQL usage

Hi All,
Is it possible to create a database (databse.mdf file) at a specified
location using OSQL ?
Thanks in advance for any help,
Piyush
hi Piyush,
"Piyush" <anonymus@.hotmail.com> ha scritto nel messaggio
news:%23XlPdRfqEHA.3728@.TK2MSFTNGP09.phx.gbl
> Hi All,
> Is it possible to create a database (databse.mdf file) at a specified
> location using OSQL ?
> Thanks in advance for any help,
> Piyush
a good article about oSql can be found at
http://support.microsoft.com/default...EN-US;q325003, and, of
course, it is possible to define a specific database's files location, using
the standard CREATE DATABASE syntax
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_create_1up1.asp)
for your convenience, you can download the SQL Server Books On Line at
http://www.microsoft.com/sql/techinf...000/books.asp, the on line
help for SQL Server, including all Transact-SQL reference
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea,
The create Database scheme works fine for me.
regards,
Piyush
But is this possible using OSQL.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2scla2F1ijfkfU1@.uni-berlin.de...
> hi Piyush,
> "Piyush" <anonymus@.hotmail.com> ha scritto nel messaggio
> news:%23XlPdRfqEHA.3728@.TK2MSFTNGP09.phx.gbl
> a good article about oSql can be found at
> http://support.microsoft.com/default...EN-US;q325003, and, of
> course, it is possible to define a specific database's files location,
using
> the standard CREATE DATABASE syntax
>
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
> _create_1up1.asp)
> for your convenience, you can download the SQL Server Books On Line at
> http://www.microsoft.com/sql/techinf...000/books.asp, the on
line
> help for SQL Server, including all Transact-SQL reference
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>