Suppose i have created a mapped network drive on my workingstation (\\DatabaseServer\share1).
This mapped drive , points to my database server, where i have a shared directory.
My txt files are on that share (on SQL Server server).
If i send the remote name of my mapped drive (\\databaseserver\share1) to my stored procedure that is on my SQL Server, will the SQL Server import the files internally (not trought network)?
(my stored procedure imports data trought bulk insert functionality)
In other words:
If i have a Shared Directory in my SQL Server server (for instance, named pedro1) and send to the stored procedure located on that SQL Server server the path \\SQL Server\pedro1 , will the data be imported trought network? or will the data be imported localy, as if i had sent the full local path like c:\pedro1?
tks,
Pedro