Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

thanks

nat

share|improve this question
    
Why not set SQL profiler running during the day(which can be a little resource heavy so you know), find a time when the error occurred and check exactly what query has hit the SQL server. –  boburob Jul 19 '12 at 21:51
    
Also, to me this sounds like an issue with the code rather than SQL server. I find it hard to believe a column will drop of on a SQL query! –  boburob Jul 19 '12 at 21:58
    
the column is definitely there.. the query returns rows, but then falls over saying it cant find the column its just grabbed.. I find this most odd –  nat Jul 20 '12 at 8:17
    
Catch the error and dump the query results into a file? –  boburob Jul 20 '12 at 10:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.