Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

  • February 5, 2009 at 2:18 am

    #938661

    Carleton (2/5/2009)

    Thanks Jonathan for this very timely article! Can you advise whether this CLR function will work for UNC paths?

    Thanks,

    Carleton

    As long as the SQL Service Account has access to the UNC path, yes. If security needs further abstraction, a windows user could be explicitly impersonated in code to allow only specific users access to the UNC paths as well.

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]