alternative way to use trigger  
Author Message
IanMWalker





PostPosted: Wed Jul 30 14:22:06 CDT 2003 Top

SQL Server Developer >> alternative way to use trigger

Hi all, what is the alternative way to use trigger
(insert, delete, update) that have column data type
(text)? I don't want to recreate my table. Thanks a lot

SQL Server14  
 
 
Wayne





PostPosted: Wed Jul 30 14:22:06 CDT 2003 Top

SQL Server Developer >> alternative way to use trigger Take a look at Instead of Triggers... they can see text columns. (They are
doc'd in books on line.)

--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), C****te, NC
www.computeredservices.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org




> Hi all, what is the alternative way to use trigger
> (insert, delete, update) that have column data type
> (text)? I don't want to recreate my table. Thanks a lot


 
 
Kalen





PostPosted: Wed Jul 30 14:35:50 CDT 2003 Top

SQL Server Developer >> alternative way to use trigger Just a note, you didn't say what version you were using, and Instead of
Triggers are only available in SQL Server 2000.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com




> Take a look at Instead of Triggers... they can see text columns. (They are
> doc'd in books on line.)
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), C****te, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it
community
> of SQL Server professionals.
> www.sqlpass.org
>
>


> > Hi all, what is the alternative way to use trigger
> > (insert, delete, update) that have column data type
> > (text)? I don't want to recreate my table. Thanks a lot
>
>