Thursday, August 22, 2019

Map network drive with sql

exec xp_cmdshell 'net use Z: \\192.01.01.10\FileStorage [Password] /user:192.01.01.10\Administrator'(Username)

--exec xp_cmdshell 'net use Z: /delete'

--exec xp_cmdshell 'dir Z:'

For more ref : https://www.mytechmantra.com/LearnSQLServer/Configure-Network-Drive-Visible-for-SQL-Server-During-Backup-and-Restore-Using-SSMS/

No comments:

Post a Comment

📱Build WhatsApp Bot using .NET + OpenAI

   In this article, you will learn how to build a real-world WhatsApp chatbot using ASP.NET Core and OpenAI. This bot can automatically repl...