How to map network drive in SQL query without using XP_CMDSHELL
<p>Looking to just map a network drive with a different AD account in a SQL query.</p>

<p>XP_CMDSHELL is disabled in our environment.  I could technically turn it on, then "net use" the drive, and turn it off again in a query, but was looking for a cleaner solution??</p>