I have a stored proc that's looping summarizing data from another table. The problem is, when a shutdown is requested for the Sybase server, the shutdown waits forever on this stored proc.
I don't want to do "shutdown with nowait" because that can potentially corrupt db's.
The sysprocesses table in the master db shows "CHECKPOINT" for the thread running the shutdown command. Since that can show up for regular checkpoint commands, it can't be used to detect a shutdown.
Is there anyway for my looping stored proc to detect a shutdown is in progress so it can gracefully exit and let the shutdown proceed?
Chevy Chase, MD