I am running SQL Server 7 and am having a reoccuring problem with the following code. select Count(EmployeeID) as EmpCount from Employee where AgencyID = 5 This query runs correctly 99% of the time. Then at no particular time all "count" statements cease to work in a particular database table. It continues to not work until I restart SQL Server. Then it works again. Any ideas what might cause this?