Row_namber() is 2005 only and it is this that generates the id column which is later filterd on.

in 2000 i would the intial record set into a table variable...

you need to use a case statement,

insert table

select case when @var is null then then field else @var end

I dont think you neeed a cursor here and thats what will be slowing it down most.

Get the data you want to update out of oracle into a table...

you can see what user is executing the sp using sql profiler. Set that up then run the app find the user and give it bcp rights

drop

table #test

declare

@rows int

create

table #test (id int

remembered @@rowcount

yep i have tried robert's solution on 2005 it doesnt work. Would be interested to see any other solution but i dont think there is one.

i found a way

use db1

declare

@statement nvarchar(1000)

select

@statement = 'create proc newsp...

i am automating the setup of replication which has customised replication stored procs. I want the sql which alters the default generated sps to be contained in an sp which...

tried that it tells me that alter\create must be the first statement in the batch

Thanks guys.

What actually happened was i went to an interview abroad having had my salary expectation confirmed. It cost me in flights and hotels. On the morning i arrived...

That is certainly true Andrew. But the specific claim i encountered was that putting SQL Server DBA on your CV implies that you have certification. Surely that is nonsense.

or any pointers of course

does the linked server have a different quoted identifier setting or collation?

same as principle column