+ Post New Thread
Results 1 to 5 of 5
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 ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,689
    Thank Post
    516
    Thanked 2,455 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833

    MSSQL Timeout

    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.

    Any ideas?

  2. #2

    Join Date
    Apr 2006
    Posts
    389
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    Are you doing this manually through the grid, or via some SQL?

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,689
    Thank Post
    516
    Thanked 2,455 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833
    Quote Originally Posted by theriver View Post
    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.

  4. #4

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,156
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    124
    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??

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,689
    Thank Post
    516
    Thanked 2,455 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833
    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).

SHARE:
+ Post New Thread

Similar Threads

  1. Smoothwall - Session Timeout?
    By linkazoid in forum Internet Related/Filtering/Firewall
    Replies: 2
    Last Post: 19th March 2009, 01:23 PM
  2. Thinstation timeout
    By dperrott in forum Thin Client and Virtual Machines
    Replies: 1
    Last Post: 29th October 2008, 12:32 PM
  3. [CLOSED] Improvement: Logout Timeout?
    By bjohnny42 in forum EduGeek.net Site Problems
    Replies: 1
    Last Post: 2nd May 2008, 10:53 AM
  4. Timeout settings when deploying Sophos
    By KarlGoddard in forum Windows
    Replies: 0
    Last Post: 9th January 2008, 09:26 AM
  5. ARP Timeout
    By mrforgetful in forum Wireless Networks
    Replies: 6
    Last Post: 14th May 2007, 07:17 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •