Results 1 to 2 of 2

Thread: how do I list contents of file directory in the SQL Query Analyzer

  1. 04-13-2006, 10:06 AM #1
    sgar
    sgar is offline Registered User
    Join Date
    Mar 2006
    Posts
    14

    how do I list contents of file directory in the SQL Query Analyzer

    how do I list contents of file directory in the SQL Query Analyzer
    Reply With Quote Reply With Quote
  2. 04-13-2006, 10:20 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    master..xp_cmdshell 'dir C:\'

    displays the content of the directory.

    you should be a sysadmin to execute this command.

    You could do the same using FSO and sp_oamethod as well.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules