Update trigger

[Mary Phelps]

Could somebody show me how to update a trigger. I havent created any
trigger but it exists in one of the databases we bought for shopping
cart. I have to make some modifications to that.

[Bob Barrows]

More details please:
SQL Server version?
Have you installed the client tools (SSMS or Enterprise Manager)?
Is the database encrypted?

Actually, why don't you have the people you bought the database from fix
the bug? Won't modifying the trigger yourself invalidate the warranty?

--
HTH,
Bob Barrows

[Sylvain Lafontaine]

If you have the script for the trigger, you must replace the word Create
with the word Alter because the trigger already exists (or drop it before);
so if you have something like:

Create Trigger dbo.MyTrigger on dbo.MyTable for Insert as ....

then replace the word Create with Alter to get:

Alter Trigger dbo.MyTrigger on dbo.MyTable for Insert as ....

--
Sylvain Lafontaine, ing.
MVP - Access
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

"Mary Phelps" <icanh...@gmail.com> wrote in message
news:194eae94-29aa-4205...@v41g2000yqv.googlegroups.com...

[Erland Sommarskog]

Seroiusly, if you don't know how to change a trigger, you should
attempt doing this in a third-party application. It is likely that
you cause no more harm than good. Contact the vendor's support desk.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx