For example i run these statements on the query analyzer

Declare @ret as int

Declare @sql as nvarchar(4000)

Set @sql = 'Insert into mass.corpsafeacct.dbo.saf values(1)'

Exec sp_Executesql @sql

Select...

I have already read the article but could not find if there is any solution for OLE/DB errors as the stored procedure simply aborts the whole execution without going to...

Thnks for the reply, but the problem is little different.

Actually I have to create objects at the linked server that is B.

I have a script that takes 4 inputs.

SourceServer =...