Wednesday, April 25, 2012

To Connect and Disconnect a mapped drive using SQL

To Connect:


Exec master.dbo.xp_cmdshell 'net use x: \\123.456.78.90\Shared Password /User:Domain\UID /Persistent:yes'




To Disconnect:


Exec master.dbo.xp_cmdshell 'net use x: /delete'

No comments:

Post a Comment