weblogs.sqlteam.com/brettk/2005/06/28/6895

Preview meta tags from the weblogs.sqlteam.com website.

Linked Hostnames

2

Search Engine Appearance

Google

https://weblogs.sqlteam.com/brettk/2005/06/28/6895

How do I use the DOS Command dir in T-SQL

Well, the short answer is you don't. The modified answer is that you can use the code listed in this post. The longer answer is that you can use xp_cmdshell to do this (Which is what the stored procedure in this post does), and must be either a member of the sysadmin account, or granted execution, say to a new role, and users can be placed in that role.



Bing

How do I use the DOS Command dir in T-SQL

https://weblogs.sqlteam.com/brettk/2005/06/28/6895

Well, the short answer is you don't. The modified answer is that you can use the code listed in this post. The longer answer is that you can use xp_cmdshell to do this (Which is what the stored procedure in this post does), and must be either a member of the sysadmin account, or granted execution, say to a new role, and users can be placed in that role.



DuckDuckGo

https://weblogs.sqlteam.com/brettk/2005/06/28/6895

How do I use the DOS Command dir in T-SQL

Well, the short answer is you don't. The modified answer is that you can use the code listed in this post. The longer answer is that you can use xp_cmdshell to do this (Which is what the stored procedure in this post does), and must be either a member of the sysadmin account, or granted execution, say to a new role, and users can be placed in that role.

  • General Meta Tags

    6
    • title
      How do I use the DOS Command dir in T-SQL | Brett Kaiser (x002548) Blog
    • charset
      utf-8
    • viewport
      width=device-width, initial-scale=1, shrink-to-fit=no
    • article:published_time
      2005-06-28T10:33:00-05:00
    • article:modified_time
      2005-10-12T09:07:00-05:00

  • Open Graph Meta Tags

    4
    • og:title
      How do I use the DOS Command dir in T-SQL
    • og:description
      Well, the short answer is you don't. The modified answer is that you can use the code listed in this post. The longer answer is that you can use xp_cmdshell to do this (Which is what the stored procedure in this post does), and must be either a member of the sysadmin account, or granted execution, say to a new role, and users can be placed in that role.
    • og:type
      article
    • og:url
      https://weblogs.sqlteam.com/brettk/2005/06/28/6895/

  • Twitter Meta Tags

    3
    • twitter:card
      summary
    • twitter:title
      How do I use the DOS Command dir in T-SQL
    • twitter:description
      Well, the short answer is you don't. The modified answer is that you can use the code listed in this post. The longer answer is that you can use xp_cmdshell to do this (Which is what the stored procedure in this post does), and must be either a member of the sysadmin account, or granted execution, say to a new role, and users can be placed in that role.

  • Link Tags

    2
    • canonical
      https://weblogs.sqlteam.com/brettk/2005/06/28/6895/
    • stylesheet
      https://weblogs.sqlteam.com/brettk/css/style.css

Links

6