Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unhappy Unanswered: Problem with system table 'sysprocesses'


    I suppose that it's well known problem... and may be simple to solve it. I use ASE 11.0.3. I connect to the database from my application. Running my application it's necessary to log in. Than in system table 'sysprocesses' my process appears... When I exit my program (disconnect from the database) table 'sysprocesses' refreshes and my process is no longer there. But when I disconnect physicly for example by reseting the computer my process still exists in 'sysprocesses'... I want to find out that the concrete process is no longer connected to the database, so I check 'sysprocesses' looking for a concrete 'spid' number. My number is there but it should be in fact. How to refresh that table or how to find out that I'm no longer connected...?

    Thanks in advance,

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    sysprocesses infact is a system view. What that means is you cannot refersh it.

    Normally the SQL Server engine would clean the dead spids. In your case if you are seeing the spid still active(runnable) in the sp_who output. This means it has now become an phantom spid. I'm not sure what you can do about it other than shutdown and restart SQL Server.

Posting Permissions

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