DB Triggers

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

Programmability -> Database Triggers.

Under Programmability, first item is Stored Procedures, second item is Functions, third item is Database Triggers.

Anamika SSCertifiable Points: 6202 More actions · Answer 2

hi suresh,

thanx for your quick reply.

my sys.triggers shows more than 100 triggers but my database triggers shows nothing.

if i query syscomments i can get the text of the triggers also. but could not see them under database triggers...

do i have to enable any options?

regards

viji

Suresh B. SSC-Insane Points: 22986 More actions · Answer 3

Hi Viji,

No need to enable any option. It appears automatically just like Functions and stored procedures.

For SQL Server 2000 it will not appear.

Regards,

Suresh

Anamika SSCertifiable Points: 6202 More actions · Answer 4

i'm using sql server 2005. for that also its not appearing........

wht to do.

but i've created a new trigger that is appearing. the others which is having type as TR in objects table are not appearing.........

regards

viji

Anamika SSCertifiable Points: 6202 More actions · Answer 5

hi,

i found........

if i create a trigger on database then it comes under database triggers........

or else

it comes under that particular table itself. 😀

columns........keys......constraints..........triggers

thanx

regards

viji

Suresh B. SSC-Insane Points: 22986 More actions · Answer 6

Glad to know that you found it.:-)

Thanks for posting it.

I was about to say that hundres of database triggers cannot be created on single database.

Anamika SSCertifiable Points: 6202 More actions · Answer 7

obviously,

hundreds of database triggers cannot be created on single database.

but i was searhing the normal triggers in data base triggers txtPost_CommentEmoticon(':hehe:');

thnx,

regards

viji