Posted on 2004-03-20
Last Modified: 2012-05-04
How many max triggers can we write in SQL server?Whether trigger can be used other than update,insert,delete?
Question by:sanjusambhe

Expert Comment

ID: 10643300
I feel it is Virtually unlimited numbers , depending on the free space in the SQL server machine.

Accepted Solution

DonRameshSachin earned 250 total points
ID: 10646749
As pamboo said, it is unlimited in SQL 2k depending upon the size of the ur HDD.
No triggers cannot be used other than Insert, update and Delete. Basically, trigger is an event which would be fired during an Action. Here the Action is, Insert/ Delete/ Update.


Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
mergeTwo  challenge 13 83
oracle query help 18 99
Adding Namespace to the second node of the xml 16 62
Please help| Getting the syntax error in below query. 2 42
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now