sql server trigger update database

Hi Ramesh,

Use SP_HelpText to get the script of the existing trigger in the database.
if you have the name of the trigger then follow the following steps:
(1) SP_HELPTEXT <Your Trigger Name>
(2) Copy the Script and modify it as per your requirement then change the Create Statement to Alter and execute. It will modify your trigger.
if you need to check the existing triggers in the database then use this query

SELECT name FROM SYSOBJECTS WHERE xtype='tr'

Thanks,
Lakhan Pal

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator

thx Lakhan Pal...

Thanks
RameSH sinGH

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator

Refer this link

http://www.codeproject.com/Articles/38808/Overview-of-SQL-Server-database-Triggers

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator

Refer this link too
http://msdn.microsoft.com/en-us/library/ms189799.aspx

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator

there are two options
under database --> programmability --> database triggers
under a table in database --> triggers

Thanks and Regards,

Vinay Gandhi
www.quadtechindia.com

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator