Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-22 : 08:31:30
|
| Rob writes "I write a bcp command but can't get all the data to appear because of the following error.Query hints exceed maximum command buffer size of 1023 bytes (1601 bytes input).When I trim my statement down to 1023 bytes it works splendidly. Thanks for article pointing me in the right direction on xp_cmdshell with bcp!Unfortunately, I need all the data in my query and can't trim it down to 1032 bytes.Do you know how I can work around this error message without having to sacrifice the data I need?Thanks in advance for any help you may provide on this subject.Rob" |
|
|
srf
Starting Member
42 Posts |
Posted - 2002-10-22 : 12:33:19
|
| I assume you're using queryout? Try creating a sproc or view. |
 |
|
|
|
|
|
BCP returns error when using xp_cmdshell