Eventhough I agree with the Idea that articles for beginers and people that never used a feature before should be welcome I totaly disagree with the title "The best kept secret". Like...

There is nothing wrong in having a code generator for the triggers. The bad part is to use dynamic sql in the generated code!

Update a Set Type = b.Type

FROM

     TABLESOURCE a

     join

     ( Select File, Type, Max(Version)

        FROM TABLESOURCE

        WHERE Type is not null -- With this you may not need...

John is correct there is not direct access to the inserted table from dynamic SQL. Which you shouldn't be using anyways on a trigger

Update a set StartDate = IsNull(SD,0), EndDate = IsNull(ED,0)

From TABLE_A a

       Left join  ( Select Membernbr, Min(StartDate) SD, Max(Endate) ED

             From TABLE_B

            GROUP BY Membernbr ) b  on a.Membernbr =...

My favorite ad: "Learn English"

Previous version of the forumns allowed for surrounding the code between brackets but after the "upgrade" that feature was gone

Easy to what?....

The beautiful indentation that it has makes it even better

Cory,

EM does not supports such list. You are better of if you need some graphical feed back with the "Diagram" or a Modeling tool that can perform reverse engineering

It has been a while since I upgraded an SQL7 to 2k but the process should be painless. There is a Backward Compatibility Chapter in BOL that describes the possible changes/issues....

I've been biten by that alooooooot of times ( Uh I don't have a backup...   )

that's why I keep saying this to...

write a print statement before the exec statement and see where it stops

If you can't upgrade to 2000 you pretty much have very limited options:

1. Remove fk/pkey -  perform update accross all tables - put back fk/pkeys (this is the standard way)

2. Create a copy...

Let me also remind you that SQL 7 does not supports CASCADE Actions that's for 2000 

That is not correct!

sp_help is a wrapper that calls sp_get_composite_job_info which is a wrapper to call xp_sqlagent_enum_jobs

Cheers!!!