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

just some readingstuff.

http://www.sqlservercentral.com/columnists/awarren/shouldyoubuyasan.asp

http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asp

http://www.sqlservercentral.com/columnists/kpart/scalingout.asp

http://www.sql-server-performance.com/ew_san.asp

and

forum http://www.sqlservercentral.com/forums/messages.aspx?forumid=54

it works fine overhere

what's your sqlserver version an sp /hotfisex ?