> Hi,
> I wonder how to create trigger (if it is possible) from stored
> procedure - my trigger is too long to pass it from my program and i have
to
> create a trigger for user tables when they are creating them... Any
> suggestions ??
> Thanks
> Dariusz Hoszowski
>
>

> Yes it would pe possible if you place the TSQL code inside the procedure.
>
> But it is not recommendend, for waht reasons do you want to place the
> trigger creation in the procedure ?
>
> Jens Süßmeyer.
>
>
> <hoszowskid@poludnie.poczta.wroclaw.pl> schrieb im Newsbeitrag
> news:OPoqOSJdDHA.1460@TK2MSFTNGP10.phx.gbl...
> > Hi,
> > I wonder how to create trigger (if it is possible) from stored
> > procedure - my trigger is too long to pass it from my program and i have
> to
> > create a trigger for user tables when they are creating them... Any
> > suggestions ??
> > Thanks
> > Dariusz Hoszowski
> >
> >
>
>

> Thanks, but ... my name of trigger and table it is place on have to be
> dynamically implement to the trigger (for example when i create the
> table name TEST then i have to place a trigger on it so i have to make
> it's name like TEST_ON_DELETE an table on which it will be placed 'ON
> TEST'). So my dynamic trigger creation is for that. Maybe is another way
> to do that but i don't know it.

> Dariusz Hoszowski (hoszowskid@poludnie.poczta.wroclaw.pl) writes:
> > Thanks, but ... my name of trigger and table it is place on have to be
> > dynamically implement to the trigger (for example when i create the
> > table name TEST then i have to place a trigger on it so i have to make
> > it's name like TEST_ON_DELETE an table on which it will be placed 'ON
> > TEST'). So my dynamic trigger creation is for that. Maybe is another way
> > to do that but i don't know it.
>
> Obviously you could use dynamic SQL to create both the table and the
> trigger dynamically, but tables and triggers are not something you are
> supposed to create dynamically. Tables and triggers are supposed to be
> part of a data model, that is largely static.
>
> Maybe you could explain the business problem you are trying to solve?

>
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp