Windows Server 2000/2003 Thread, MSSQL Timeout in Technical; I have a database in MSSQL 2005 express and one of the tables countains 'money' columns. When one of these ...
24th September 2009, 03:59 PM #1
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.
24th September 2009, 10:18 PM #2
Are you doing this manually through the grid, or via some SQL?
24th September 2009, 10:20 PM #3
This was manually, via SQL Management Studio Express, on a LAN by an admin user.
Originally Posted by theriver
24th September 2009, 10:25 PM #4
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??
25th September 2009, 10:03 AM #5
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).
By linkazoid in forum Internet Related/Filtering/Firewall
Last Post: 19th March 2009, 02:23 PM
By dperrott in forum Thin Client and Virtual Machines
Last Post: 29th October 2008, 01:32 PM
By bjohnny42 in forum EduGeek.net Site Problems
Last Post: 2nd May 2008, 11:53 AM
By KarlGoddard in forum Windows
Last Post: 9th January 2008, 10:26 AM
By mrforgetful in forum Wireless Networks
Last Post: 14th May 2007, 08:17 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)