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

Comment Utility
I feel it is Virtually unlimited numbers , depending on the free space in the SQL server machine.

Accepted Solution

DonRameshSachin earned 250 total points
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
linearIn  challenge 23 65
strCount chalenge 3 50
pairs challenge 5 44
autoit - check if option is checked in another program 2 65
This article will show, step by step, how to integrate R code into a R Sweave document
A short article about problems I had with the new location API and permissions in Marshmallow
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
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…

762 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

7 Experts available now in Live!

Get 1:1 Help Now