Viewing 7 posts - 1 through 8 (of 8 total)
Well here's my thinking (which is probably a bit twisted...) on it and why this didn't occur to me at first...
Sure, I know it *returns* the same value, but that...
April 30, 2009 at 12:57 pm
Yeah, that did it. Odd, though. Seems to me that the function should anticipate something like that.
April 30, 2009 at 11:27 am
Just to update, applying CU2 did indeed fix the issue.
April 21, 2009 at 9:16 pm
As said, it's quite painful. You'd be better off to do a re-install if possible.
April 20, 2009 at 4:27 pm
I think I found it:
http://support.microsoft.com/kb/959028
If I issue SET XACT_ABORT OFF;
before hand the parse runs without error (for that session).
Dev machine is on 9.00.4035 so it makes sense I guess....
April 20, 2009 at 1:44 pm
Same error (as above) for all three.
Everything else appears to run fine, it's just the "Parse" functionality.
April 20, 2009 at 12:55 pm
I log in with sa so authentication issues are doubtful.
No relevant messages in the SQL logs or Windows event logs.
DBCC CHECKDB returns no errors for master, msdb or a few...
April 20, 2009 at 12:14 pm
Viewing 7 posts - 1 through 8 (of 8 total)