Avatar of Dale Fye
Dale Fye
Flag for United States of America

asked on 

Using T-SQL (SQL Server 2008 R2) to determine whether file exist on server and delete it

I'm working on a procedure to determine whether a file exists on the path referenced in a field of my database.

In some instances, I will need to be able to copy this file to another location on my server and then delete the original once I've confirmed that the copy operation was successful.

how can I accomplish this with T-SQL in Sql Server 2008 R2
* T-SQLMicrosoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon