Re: FTPing and Calling an EXE from a SQL Statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chris Hayes (cp.hayesATsbcglobal.net_at_nospam.nospam)
Date: 01/23/05 

Date: Sat, 22 Jan 2005 22:37:28 -0600

Hi Mr. Tea...

Oh no nothing Viral here at all...

Just solving a business problem: I'm finishing up an application that will
be distributed to about 300 sites...and I need to get back up copies of the
sites databases so that we (the central IT staff) can adequately back the
files up. But first I need to encrypt the SQL Server backup file and then
FTP it up to our secure FTP server...

It's a lot of overhead...I wish this was an internet application with 300
end users using a central Database server...

Oh, well this is the job I've been handed...

Chris

"Lee Tudor" <mr_tea@ntlworld.com> wrote in message
news:MSwId.1277$3j6.820@newsfe4-gui.ntli.net...
> That sounds kind of viral to me :)
> a certain SQL spider worm uses a similar technique.
>
> Mr Tea
>
> "Chris Hayes" <cp.hayesATsbcglobal.net@nospam.nospam> wrote in message
> news:e3i0aTCAFHA.3592@TK2MSFTNGP09.phx.gbl...
>> Greetings,
>>
>> I've seen this done in other places...I wish I had paid better attention
>> because I can't remember how it was all done.
>>
>> But can someone point me the resources to accomplish my stated desires to
>> FTP a file from within a SQL Statement and also to run an .EXE from
>> within a SQL Statement...
>>
>> Thanks,
>>
>> Chris
>>
>>
>>
>>
>
>

Relevant Pages

  • Re: Is there any problem by running both ftp and Http in the same Machine
    ... SQL best practices in general. ... > The problem associated with me is that, our client wants to remove our ftp ... They actually changed the Http server and the FTP ... > Servers is using System Administrator as the database user. ...
    (microsoft.public.windows.server.security)
  • Re: Is there any problem by running both ftp and Http in the same Machine
    ... We use the FTP to simply Upload the new pages. ... First Both FTP and HTTP were ... on the same server, so we can test our pages without any help from there. ... > SQL best practices in general. ...
    (microsoft.public.windows.server.security)
  • Re: Accessing SQL data from an ACCESS app...
    ... A pass-through query passes the SQL statement to the server so that the ... pretty sure you can find more information in the Access or SQL Server help. ...
    (microsoft.public.sqlserver.odbc)
  • RE: process could not connect to Distributor
    ... Ftp support in SQL replication applies only to transfer of snapshot ... movement of SQL changes would require a regular connection to SQL ... server (Publisher and Distributor). ...
    (microsoft.public.sqlserver.replication)
  • General performance question
    ... SQL Server 2000 has an efficient algorithm to find any existing execution ... existing plans instead of compiling every SQL statement. ...
    (microsoft.public.sqlserver.programming)