Try SET XACT_ABORT ON; in the beginning of your code and turn it OFF after that.

I would use the hint first (nolock) .. if that still doesn't work I would select the rows first into a variable table and after that I would use...

Is not happy with this sort of parameters: @[first-name]

try: @first_name for example.

Run this and try your statements again.

sp_configure @configname= 'Ad Hoc Distributed Queries',@configvalue = 1

go

reconfigure

go

Run this

sp_configure @configname = 'show advanced options',@configvalue = 1

go

reconfigure

go

if u are not able to see all the options.

Run this

sp_configure @configname = 'show advanced options',@configvalue = 1

go

reconfigure

go

if you are not able to see all the options.

what are the values for Ad Hoc Distributed Queries ?

Can you please display the output of this sp_configure.

Maybe this http://vstoolsforum.com/forums/p/170/366.aspx can help you.

I would take a look at this sort of things maybe ... :

select ...

from

sys.dm_os_waiting_tasks wtt...

select top 1 * from fn_dblog(null, null) ?

There is an interesting documentation here http://technet.microsoft.com/en-us/library/cc280384.aspx, maybe it helps.

Can you give it a try replacing this line: SET @sql = 'ALTER TABLE #tblPartners ADD [' + @PARTNER_CODE + '_GFF] varchar(20)' ?

Have you tried to put the 'begin transaction' just after the set @interval = 50000 line ?

Use this one instead:

select * from sys.all_objects

where

type = 'FN' -- SQL scalar function