sp_move_file system procedure

sp_move_file(
source_path
, destination_path
)

source_path Use this LONG NVARCHAR parameter to specify the file path, including file name, of the file to be moved. The path can be absolute or relative. A relative path is resolved to the current working directory of the database server. When the sandbox feature is enabled, the absolute and relative paths refer to the directory where the main database file is located.
destination_path Use this LONG NVARCHAR parameter to specify the destination file path, including file name, on the computer. The path can be absolute or relative. A relative path is resolved relative to the current working directory of the database server. When the sandbox feature is enabled, the absolute and relative paths refer to the directory where the main database file is located.

This function returns 0 on success and 1 on failure.

This function moves a file from one directory to another.

You must have the READ FILE and WRITE FILE system privileges.

The following statement moves the file license.txt to the c:\temp directory and gives it a new name.

SELECT sp_move_file('c:\\sqlany\\license.txt', 'c:\\temp\\license.bkp');

The file no longer exists in its original location.

The following statement restores the file to its original name and location.

SELECT sp_move_file('c:\\temp\\license.bkp', 'c:\\sqlany\\license.txt');