sp_delete_file system procedure

sp_delete_file( file_path )

file_path Use this LONG NVARCHAR parameter to specify the file path, including file name, of the file to be deleted. 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 deletes the specified file from the computer.

You must be connected to a database server on the computer where the file resides to run this procedure.

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

The following statement deletes the license.bkp file from the temp directory.

SELECT sp_delete_file('c:\\temp\\license.bkp');