Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

thresholdaction in sybase

Status
Not open for further replies.

maylee

IS-IT--Management
Dec 26, 2001
2
US
Hi all,
Any of you know where should I place my thresholdaction store procedure with ASE database version 12.0.
Thanks
 
Hi !

You have two choices.

1- place thresholdaction store procedure in the database where the thresholdaction is set.
2- place thresholdaction store procedure in the sybsystemprocs database.

ASE will first search thresholdaction store procedure in the current database in use. If is not here, then ASE will search in sybsystemprocs db.

I suggest to place thresholdaction store procedure in sybsystemprocs db when this one performs DBA tasks (like dump tran...).

see you...



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top