I have a database in MSSQL 2005 express and one of the tables countains 'money' columns. When one of these columns is negative, and we want to change it to a non-negative (be that 0 or +) the database doesn't commit the data and returns a timeout with 'the timeout period elapsed prior to completion of the operation or the server is not responding'.
When I alter positive values to positive or positive to negative, it works just fine.
Are you doing this manually through the grid, or via some SQL?
This was manually, via SQL Management Studio Express, on a LAN by an admin user.
Originally Posted by theriver
Are there any database triggers? Can't see any reason why changing from + to - works but the other way doesn't - it's got to involve much the same amount of processing but if there's a trigger which is looking at the change in value and "doing something" then maybe that's failing??
I've figured out what the problem is... The error message should've told me really.
Some software accessing the database isn't closing connections properly, so that particular field is locked by one of them. (and, apparently 21 other fields).