Microsoft Events Sharepoint - MOSS, SQL, WINDOWS Events and resolutions in one place

Source: Windows SharePoint Services 3
Event ID: 5586
Error: 

Unknown SQL Exception 4104 occured. Additional error information from SQL Server is included below.
The multi-part identifier "UserData.tp_ID" could not be bound.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

When you see this kind of error you can be sure that one of your lists reach magic level of 500 items.
So the guestion is : which one ? This is a big problem when your enviroment has tousends of them.

First you need to check SharePoint log because there is answer.
1) ConnectionString: 'Data Source=InstanceName;Initial Catalog=DBName;Integrated Security=True;Enlist=False;Connect Timeout=15'

Hint for DB name

2) Parameter: '@DN' Type: NVarChar Size: 260 Direction: Input Value: 'sites/ABC/newpost/Lists/abc'

So when we knew the name of list we can check how many items are there :






As you see we have 506 items . When you try to choose "Show Filter Choices" you will see:




Ok so how we can fix it ?

We can try install the WSS Cumulative Update from June 30, 2009. In my opinion this won't help. The second option is to remove \ close \ move some of items. I can bet that after second step eveything will back to normal.