That's the concept of triggers, fire always when from the designed action.

If you have full control regarding the invocation of the designed...

It might even be from a _new_ mainframe db

create function dbo.fnGetNextRecNo(@company xx, @customer xx, @glperiod xx, @transaction)

returns smallint

as

    begin

       ...

If for any reason your database collation is changed, your existing tables will not be affected. If they used the "old" db-collation, they will still use the "old" db-collation, even...

how about :

alter table mytable

alter column mycol type_and_length COLLATE mynewcollation

Ofcourse backup before!!

Maybe even script the full db, create...

the trigger will always be firred, but will only perform some stuf when meeting some criteria.

CREATE TRIGGER TR_mytable_ins ON [Mytable]

FOR INSERT

AS

BEGIN

if inserted.Mycolumn = 'myvalue'

begin

  my work to be done

end

END

Keep in mind that when you have existing indexes with the same column(s), ordinal and direction and you run this script, it will create extra indexes which are redundant, so...

mu 2ct

maybe edit the jobs and set 'target' to the local (test) server.

Then delete the jobs.

in addititon this testscript :

sometimes even a DBA has to proove (s)he's only human

The nice thing about "dynamic"  is that it has issues

Because "exec (@sql)" lives its own life,...

you might want to perform a left join or a not exists.

insert into tableB

select  A.* (I hate * but in this case maybe ...)

from tableA A

left join TableB...

Same player shoots again ...

Test this : 

'T_ParentMC' =...

That's correct ! Sorry for that 

I didn't notice because I didn't document that in the script at the time I developed it. 

Hi Noelson,

This is part of a script I used to convert some pk-indexes (clusterd/nonclusterd).

Test it for usability for your purpose.

Declare @TbNaam varchar(128)

set @TbNaam = 'T_Tabel'

create table ##Tmp_TbRefsW1 (

cType...

no can do.

Structured Query Language (SQL) uses a comma as a separator and not as a decimal sign.

You can avoid this problem by...