SQL Server Performance

xp_cmdshell { 'command_string' }

Discussion in 'Getting Started' started by lcerni, Sep 18, 2007.

  1. lcerni New Member

    A developer was asking me about xp_cmdshell and the length of the 'command_string'.
    Per Microsoft "Is the string that contains a command to be passed to the operating system.
    command_string is varchar(8000) or nvarchar(4000), with no default."
    He claims that he has a sql statement that is more than 8000 characters.
    Is there some clever way around the 8000 limit? Has anyone come across this situation?
    And if so how was it handled?
  2. Luis Martin Moderator

    As far I know, is up to 8000.

Share This Page