USE [master]
GO
/****** Object: StoredProcedure [dbo].[map_drive_Backup] Script Date: 6/24/2023 2:52:44 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create or ALTER PROCEDURE [dbo].[map_drive_Backup]

AS

/*
EXEC sp_configure ‘show advanced options’, ‘1’
RECONFIGURE
— this enables xp_cmdshell
EXEC sp_configure ‘xp_cmdshell’, ‘1’
RECONFIGURE
*/

EXEC xp_cmdshell

‘NET USE A: /delete’

EXEC xp_cmdshell

‘NET USE A: 192.168.1.14KiaBack Qnap@2022 /USER:username /PERSISTENT:yes’

— EXEC xp_cmdshell

— ‘NET USE B: /delete’

–EXEC xp_cmdshell

— ‘NET USE B: 192.168.1.14KiaBack xxx /USER:user /PERSISTENT:yes’