Posted by dotnetfellow on 09/12/06 23:22

All servers involved, old and new, have a default collation of
SQL_Latin1_General_CP1_CI_AS.

My Cross Server update that I execute on Server "A" is below, where

@p_str_source_workspace VARCHAR(50) = 'vit16.ais70.dbo.', and
@p_str_destination_workspace VARCHAR(50) = 'vit2.opus.dbo.'

Again, it doesn't work when I uncomment the BEGIN TRANSACTION

---------

/*
Update the source database, ensure that the archived flag is accurately
marked as 'N' if the record does not yet exist in Opus.
*/

SELECT @l_str_update = ' UPDATE ' + @p_str_source_workspace +
'pr_history SET archived = ''N'' FROM ' + @p_str_source_workspace +
'pr_history as pr0 WHERE archived = ''Y'' AND pr0.pr_hist_search NOT IN
(SELECT pr_hist_search FROM ' + @p_str_destination_workspace +
'pr_history)'

--BEGIN TRANSACTION

EXEC (@l_str_update)

---------

Thanks for keeping me in mind Erland.

• Next in forum: Re: Server configuration for MSSQL 2000 and MSSQL 2005
• Prev in forum: Re: Memory setting right ?
• Thread view: Re: cross server update problem

[Reply to this message]