Note: You should be careful in using this stored procedure as it replaces the existing file without any warnings.You can see the updated file in the destination folder. Xp_copy_file overwrites the file and does not give any warning or information. We already have a file present in theĭestination directory, but the SQL query executes successfully. Once the copy is finished, modify the source file and rerun the above T-SQL. You need to enable it in the system configuration using the sp_configure.Įnable advanced options in the master database of the SQL Server 2019 instance This extended stored procedure is available in the master database. You can download the latest version from the Microsoft URL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |