Stored Procedure to Map a drive
-
In SQL 2000, running on Windows 2003, Is there a stored procedure that will map a windows drive letter?
Thanks...Nali
-
You could try EXEC master..xp_cmdshell '< some dos command>'
-
who needs a drive when you have UNC ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I'm testing using a UNC. The share is a unix share on a 4690, and it seems like writing files to the share is significantly slower than writing files to a mapped drive. I'm using 'net use z: \\myserver\myshare' to create the mount, or the alternative 'mount myserver:/myshare z:' which seems to be much faster.
What I don't know yet is how persistent that mounting is. Will it stay that way as long as SQL is not restarted?
-
imo if you allocate a drive letter (net use z) , you should also unallocate it (net use z /delete).
Unless offcourse this is an action that would be performed very often.
Then maybe, having the allocate-step performed using a startup-proc may be a way to go.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply