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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2008-10-06 : 11:24:37
|
| Msg 510, Level 16, State 2, Line 2Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.WHAT?!?!I am usually gett 'row too large to sort' and 'can't convert varchar to datetime' when inputting date parameters to an SP. How do you do it? I type in dates.The results used to come out a few weeks ago. Now I'm getting these errors, the rowcount has risen from 120,000 or so to about 166,000 recently.Does this ring any bells for you? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-10-06 : 11:51:03
|
 - I love that link but my attention span is too short to get through the whole thing.mikebird, What stored procedure are you calling? If it is a procedure that someone in your company wrote, you need to send this problem to that person (the developer). If you (as a developer) need to de-bug this problem yourself then you need to script out the code of the stored procedure you are calling and post it here along with the parameters you have passed to it.Be One with the OptimizerTG |
 |
|
|
|
|
|
Server Being Obstinate