cmdshell output > 64

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sql7 cagao
    New Member
    • Oct 2008
    • 2

    cmdshell output > 64

    how to do the cmdshell output to be bigger then 64 bytes ?
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    What are you trying to do?

    -- CK

    Comment

    • sql7 cagao
      New Member
      • Oct 2008
      • 2

      #3
      Originally posted by ck9663
      What are you trying to do?

      -- CK
      execute ' dir /x /od c:\*.* '

      the output text is bigger then 64 bytes in size

      Comment

      • ck9663
        Recognized Expert Specialist
        • Jun 2007
        • 2878

        #4
        Originally posted by sql7 cagao
        execute ' dir /x /od c:\*.* '

        the output text is bigger then 64 bytes in size
        Create a table variable and INSERT the result into that table.

        -- CK

        Comment

        Working...