To avoid the loop you could use the following:

select ....

from Course C

inner join @CourseDescArray CDA

on substring (CDA.element,C.CourseDesc)>0

I am a SysAdmin but can't even see the script from Enterprise Manager (SQL 2000)- I could modify the sch file directly but then would have to do this every...

Thanks Jen,

I don't quite follow - On the publication properties, Articles tab the Owner is shown as dbo but the generated sch file looks like this

drop procedure [sp_MSins_tblActiveItem]

go

if exists (select *...