Create SQL Server Objects from Command Prompts

Hi

Is there any why to Create SQL Server Objects from Command Prompts like (Databases , Tables, Stored Procedures, …) ??

If you will Install some Applications Like this forums you will see the SQL Server object Created from Command Prompts

How Can I do that .. ??

And thanks with my regarding

FraasHave a look at OSQL in SQL Server BOL

Create File

Hi
Is it possible to create file on server side with sql server 2005.
lets say
I have table and PDF files stored in this table (binary)
No i want to save this file on server side to specific folder?
Best regards
Mex
Sure as long as the SQL Server service account has the permission to do so.
Simplest example is EXEC xp_cmdshell 'dir > c:\temp\junk.txt'
Linchi
"Mex" wrote:

> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
>
> Best regards
> Mex
>
>
|||On Jun 15, 8:32 am, "Mex" <redivi...@.hot.ee> wrote:
> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
> Best regards
> Mex
Sounds like a good place to use a CLR stored procedure if your app/
middle tier won't provide this.

Create File

Hi
Is it possible to create file on server side with sql server 2005.
lets say
I have table and PDF files stored in this table (binary)
No i want to save this file on server side to specific folder?
Best regards
MexSure as long as the SQL Server service account has the permission to do so.
Simplest example is EXEC xp_cmdshell 'dir > c:\temp\junk.txt'
Linchi
"Mex" wrote:

> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
>
> Best regards
> Mex
>
>|||On Jun 15, 8:32 am, "Mex" <redivi...@.hot.ee> wrote:
> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
> Best regards
> Mex
Sounds like a good place to use a CLR stored procedure if your app/
middle tier won't provide this.