Problem with column

[sthmpsn1]

I have created an SQL database and had everything working just fine. I have an ASP page that access this database. For two months now this page has worked just great until monday morning. I started recieving EOF errors on my pages. Through trial and error I have found that if I put one of the columns in my select statement it causes this error. I can put every column in my select statement but this one and it all works great. But if I include the bad column in my select statement it returns the error. Also if I use the select * statement it errors too.
My question is what can I do to fix this problem?? what would be wrong with this column?? It is called jobdescription and the datatype is text.

 

[calidrake]

You might want to try and run

DBCC CHECKDB

and see if there are any errors on the actual database. Other then that, I have never heard of one column crashing a query. Have you run the same query in query analyzer?? You could probably debug it better from there.

 

[sthmpsn1]

no I haven't I am pretty new at SQL server. How would I run that???

 

[calidrake]

go into query analyzer and just type in

DBCC CHECKDB('databasename')

if it finds errors you can either use

DBCC CHECKDB('databasename', REPAIR_FAST) or
DBCC CHECKDB('databasename', REPAIR_REBUILD)
note : make sure to surround your databasename with single quotes

the REPAIR_REBUILD will take a little longer but it checks, and rebuilds more things.

Its all in the Books-Online which comes with SQL Server.