apologies if this is not a good place to post this, but we are experiencing some very strange things with our web ap which is running on a SQL 2005 instance.
the application is a .net web app and does as you would expect a number of queries throughout the day.
but intermittently we are getting errors such as Exception message: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'column_name'. when it clearly does have that column in the query - which if run by hand works fine.. is this a symptom of the SQL instance maybe running out of memory or just being generally poorly?
certainly we cannot track any problems in the code!
unfortunately both the web app and SQL instance are on the same box which is a Xeon with 4GB of ram, so by no means uber powerful..
ps. its not just queries like the above that seem to fall over, but some linq-to-sql things to, in fact it goes through phases of not liking the DB at all.. any help/suggestions would be happily received