<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Administration
»
Shared Directory
Shared Directory
Rate Topic
Display Mode
Topic Options
Author
Message
pedro.ribeiro
pedro.ribeiro
Posted Wednesday, March 11, 2009 4:41 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Sunday, May 31, 2009 10:19 AM
Points: 103,
Visits: 982
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
Post #673089
tosscrosby
tosscrosby
Posted Wednesday, March 11, 2009 9:56 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832,
Visits: 5,316
If I understand your request correctly, the file share physically resides on your SQL server box, correct? And your stored procs refer to \\servername\..., which is the local box? If this is all correct, I believe it's a local call and won't go over the network. I always use server name as opposed to a local path so that if I move SQL to a new server, as long as my file repository remains the same, I don't have to change anything. One caveat, my file shares are always a separate machine, not my SQL Server box. But that's MY setup.
-- You can't be late until you show up.
Post #673420
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
