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?
