Configure Map Network Drive using T-SQL
GO xp_cmdshell "net use Z: \\ServerName\drive$\FolderName <password> /user:domainusername GO
Disconnect Mapped Network drives
GO Exec master.dbo.xp_cmdshell 'net use Z: /delete' GO
Configure Map Network Drive using T-SQL
GO xp_cmdshell "net use Z: \\ServerName\drive$\FolderName <password> /user:domainusername GO
Disconnect Mapped Network drives
GO Exec master.dbo.xp_cmdshell 'net use Z: /delete' GO