new and Interesting Message - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

new and Interesting Message

Author

Topic

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-08-08 : 11:35:15

Sql Server just threw its toys out of its pram and said this to me:


Msg 8632, Level 17, State 2, Line 55
Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.

Wow, I've never seen that message before.... Time to go digging.

Transact Charlie

Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

http://nosqlsolution.blogspot.co.uk/

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-08-08 : 11:47:30

Check out the first 2 results:

https://www.google.com/search?q=Internal+error%3A+An+expression+services+limit+has+been+reached.+Please+look+for+potentially+complex+expressions+in+your+query

Pretty interesting. You found a good one!

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-08-08 : 12:00:51

it's my new favorite message. It means I am *too Awesome* for SQL Server....

Or something like that anyway.

Re factored away by introducing a temporary result set. CTE's can be evil when people start writing code like


;WITH 1 AS <something>

, 2 AS <something from 1>

, 3 AS <something from 2>

, 4 AS <something from 3>

, 5 AS <something from 4>

Transact Charlie

Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

http://nosqlsolution.blogspot.co.uk/

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-08-08 : 12:10:25

That's a shame, that's one of the features I really like about CTEs. I've stacked 8 or 9 at a time but I think I've only had 2-3 nested references like that.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2012-08-09 : 11:59:10

Interesting. Someone else had this problem a while back: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112994

How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources