dbcc dumptrigger

HI All,
Can any one explain me the use of the DBCC command called dbcc
dumptrigger
Thanks and regards
PraveenAs far as I know, DBCC DUMPTRIGGER is used to set a condition based on error
number so that when that particular error occurs, a detailed dump file will
be generated. For example,
Dbcc Dumptrigger('SET', 612)
After executing this command, whenever Error number 612 is raised, dump file
containing the technical details abt error 612 will be generated.
--
Regards,
Harsh Athalye
"Nothing is impossible"
"Praveen" wrote:
> HI All,
> Can any one explain me the use of the DBCC command called dbcc
> dumptrigger
> Thanks and regards
> Praveen
>