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 - 2005-03-30 : 08:04:55
|
| Karunakaran writes "Hi all,I got the error message "query hints exceed maximum command buffer size of 1023 bytes."when i used a bcp which is written as sp.This error occurs only for the Long Query strings.So i changed the run value of min memory per query from 1024 to 4096 and then to 8192 in sysconfigures and also in syscurconfigs of the Master Database using the reconfigure statement.But still the Problem persistsCould u please tell me Am i proceeding in the right direction .If so tell me how to proceed further to solve the problem.If not please guide me in the right direction to solve the Problem.In one of the Posts i have seen that create a view for the Long query string and use the view name instead of the query string.I dont know how to proceed in this manner.Is this the only wayout or is there any other ways to solve the Problem.Please help me in this regard as soon as Possible.Thanks in AdvanceKarna" |
|
|
|
|
|
query hints exceed maximum command buffer size