Maybe what you want to look at is xp_cmdshel; if you're on version 7 or
higher you might want to consider a DTS package (allowing you to run an
Active X script) as your start point rather than a stored procedurel

> -----Original Message-----
> From: Meg Hardy [SMTP:[Email Address Removed] Sent: Friday, June 07, 2002 3:31 PM
> To: SQLDBA (E-mail)
> Subject: Search for file statement
>
> Hi Gurus!
>
> I am trying to write a sql stored procedure. At the beginning of the
> script
> it will test to see if a certain file exists. this file is the flagfile
> that is created once our load has completed. This file is produced on a
> completely different server on our network. Does anyone know of anyway
> this
> can be done? I've had a look as system sp's but am fearing now that it
> may
> be impossible... ?????
>
> Many Thanks
> Meg
>
>
>
> **********************************************************************
> DISCLAIMER
> Any opinions expressed in this email are those of the individual and not
> necessarily of Mondial Assistance (UK) Ltd. This email and any files
> transmitted with it, including replies and forwarded copies (which may
> contain alterations) subsequently transmitted from the Company, are
> confidential and solely for the use of the intended recipient. If you are
> not the intended recipient or the person responsible for delivering to the
> intended recipient, be advised that you have received this email in error
> and that any use is strictly prohibited.
>
> If you have received this email in error please notify the IT support desk
> by telephone on +44 (0)208 2393984 or via email to
> [Email Address Removed] including a copy of this message.
> Please then delete this email and destroy any copies of it. Thank you.
>
> Mondial Assistance (UK) Ltd
> Mondial House
> 102 George Street
> Croydon
> CR9 1AJ
>
> Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered
> office as above
> **********************************************************************
>
>
> This message has been checked for all known viruses by the
> MessageLabs Virus Scanning Service. For further information visit
> http://www.messagelabs.com/
MS Sql Server LazyDBA home page