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...

just to be complete :

where indid=0 gives only heaps !

where indid in (0 , 1) gives heaps and clustered...

In addidition to the other replies :

-If you are going to choose the "delete "-path, go for small transactions.

Declare @Counter int

Set @Counter = 1

Declare @TotCounter int

Set @TotCounter...

dynamic ? Think #/## temptb or @ tablevar.

Populate your temp-object with search- and replacementvalues and join it so you get the correct results.

Maybe this gets you on track:

http://www.sqlservercentral.com/scripts/contributions/100.asp

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=32921&SearchTerms=CSV

1) tell the other dba(s) you're going to redo the restore

            so (s)he doesn't  redo the reboot

2) redo the (full/pit) restore !...