Lowell (5/14/2013)
if the shared drive was already set up at the operating system level, the mapped drive would be available there, which would better and more secure.
It's been a while, but I remember there being a hitch with this approach. When xp_cmdshell is run by a member of the sysadmin Role does the SQL Server service account User have to be logged into the operating system console for the mapped drives to remain accessible to these unattended processes? Or was there a way to get the mapped drive to be available when the User is actually not logged in?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato