Declare @prevAdvancedOptions int
Declare @prevXpCmdshell int

Select @prevAdvancedOptions = cast(value_in_use as int) from sys.configurations where name = 'show advanced options'
Select @prevXpCmdshell      = cast(value_in_use as int) from sys.configurations where name = 'xp_cmdshell'

if (@prevAdvancedOptions = 0)
begin
    exec sp_configure 'show advanced options', 1
    WaitFor Delay '00:00:01.000' 
    Reconfigure --Update currently configured values for advanced options.
    WaitFor Delay '00:00:01.000' 
end

-- To enable xp_cmdshell
if (@prevXpCmdshell = 0)
begin
    exec sp_configure 'xp_cmdshell', 1
    WaitFor Delay '00:00:01.000' 
    Reconfigure  --Update currently configured values for advanced options.
    WaitFor Delay '00:00:01.000' 
end


Exec xp_cmdshell 'NET USE T:\\Server\SqlTest Password /USER: Domain\UseName'
WaitFor Delay '00:00:01.000' 
 
Exec XP_CMDSHELL 'Dir T:'
 
Use [master]
    Backup DATABASE [DBFileName] TO  DISK = N'T:\SQLDB\XFile.bak' WITH NOFORMAT, NOINIT,  
          Name = N'XFile-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

Use [master]
    Restore Database [TG_Lojistik] From  Disk = N'T:\SQLDB\XFile.bak' With  File = 1,  
           Move N'DBFileName' To N'T:\SQLDB\XFile.mdf',  
           Move N'DBFileName_log' To N'T:\SQLDB\XFile_log.ldf',  
           NoUnload,  Stats = 5

if (@prevXpCmdshell = 0)
begin
    exec sp_configure 'xp_cmdshell', 0
    WaitFor Delay '00:00:01.000' 
    Reconfigure  --Update currently configured values for advanced options.
    WaitFor Delay '00:00:01.000' 
end

If (@prevAdvancedOptions = 0)
begin
    exec sp_configure 'show advanced options', 0
    WaitFor Delay '00:00:01.000' 
    Reconfigure --Update currently configured values for advanced options.
    WaitFor Delay '00:00:01.000' 
end
Go

(30-01-2020, Saat: 20:57)FiRewaLL Adlı Kullanıcıdan Alıntı: Hiç Bu Şekilde Düşünmemiştim. Güzel bir Paylaşım Ellerinize sağlık
Ama Kod bloğunda şu <br>ler felan çıkması çok kötü yaa :S