Stored Procedure to move files

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Stored Procedure to move files

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

November 13th, 2007, 04:41 PM

gbminnock

gbminnock is offline

Registered User

Join Date: Nov 2007

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Stored Procedure to move files

Hi I need to create a stored procedure which will transfer files (images) from one location to another on the server .i.e. from c:\images to d:\images.

How is done using a stored procedure?

All help welcome.

Thanks,
Gary

Old

November 23rd, 2007, 07:44 AM

Jeff Moden Jeff Moden is offline

Jeff Moden is offline

Friend of Wrox

Join Date: Oct 2006

Posts: 475

Thanks: 0

Thanked 9 Times in 9 Posts

Default

sp_CmdShell and DOS MOVE command.

--Jeff Moden

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel rename and move files	ahzeri	Excel VBA	1	October 28th, 2007 09:27 PM
Files need to move different folder	surendran	PHP How-To	2	June 20th, 2006 10:27 PM
Move XML files from Windows to Website	ocarroll	General .NET	10	December 21st, 2004 06:30 AM
Stored Procedure help	flyin	SQL Server 2000	6	July 25th, 2004 05:18 PM
Stored Procedure to....	flyin	ADO.NET	3	March 3rd, 2004 02:01 AM