This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Sybase问题急问， 谢谢!一table A上有trigger(to insert new reocrds into table B), 每天定时enable/disable, 一直都工作得很好，可是上周五table A 上的一些新数据没inserted into B, 人家怀疑是trigger 没有按时enable
请问我可以从什么地方查到关于trigger status的history?
谢谢!
-zxcvb(朝天椒);
2005-2-21
{244}
(#2137235@0)
-
up!
-zxcvb(朝天椒);
2005-2-21
(#2137293@0)
-
did you use this: sp_hidetext trigger_name
-changshan(偷偷乐);
2005-2-21
(#2137355@0)
-
谢谢你的回复。我没有问清楚，我想要的是类似sys log的file. 我想知道在过去几天里，trigger被disable了几次，几点disable的等。我因为没有权限访问sys log所以只好在database 里找
-zxcvb(朝天椒);
2005-2-21
{23}
(#2137405@0)
-
Is the auditing turned on?
-handd(大熊猫®);
2005-2-21
(#2137425@0)
-
还真不知道，这auditing是啥?
-zxcvb(朝天椒);
2005-2-21
(#2137434@0)
-
找到了，一大chapter, 我得使劲学啊, 谢谢你
-zxcvb(朝天椒);
2005-2-21
(#2137440@0)
-
The enable/disable trigger is valid only within the client session and does not affect other sessions and hence there is no status actually associated with the trigger. (ZT)This is unlike oracle which does have a permenant way of enabling/disabling triggers.
-handd(大熊猫®);
2005-2-21
{85}
(#2137552@0)
-
谢谢你，俺已经把这问题踢给sys admin了，要disable trigger首先要log into sybase, 让那老兄去查整个周末这个user 是不是login了吧
-zxcvb(朝天椒);
2005-2-22
(#2138830@0)
-
check here
-changshan(偷偷乐);
2005-2-21
(#2137452@0)
-
谢谢!
-zxcvb(朝天椒);
2005-2-21
(#2137519@0)