Home Forums SQL Server 2008 T-SQL (SS2K8) UNC Path of filename RE: UNC Path of filename

  • February 17, 2010 at 9:54 am

    #1120212

    not sure how much help this really is;

    but i found it in two places

    by running "NET USE" in a command window, i get results that i could use with xp_cmdshell:

    Status Local Remote Network

    -------------------------------------------------------------------------------

    OK Z: \\web1\Lowell Microsoft Windows Network

    \\TFS\Sites\HDS Web Client Network

    The command completed successfully.

    i was also able to find any mapped share in the registry; but it is mapped to my SID and not a general LOCAL_MACHINE entry or anyting.

    HKEY_USERS\S-1-5-21-1645522239-436374069-1708537768-1251\Network

    from there, there was a "Z" folder, which internally contained the mapping and a bunch of other stuff

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!