RE: Linked Server Update "Hung"

Lowell

SSC Guru

Points: 323504

July 29, 2016 at 1:26 pm

#1892715

i think it would be like this, right?

DECLARE @TermToTweak VARCHAR(30) = 'lowell@fake.com'

DECLARE @cmd VARCHAR(MAX) = 'EXECUTE AT(LinkedServer,''update P

set P.Email1 = ''' + @TermToTweak + '''

from MyDatabase.dbo.Profiles P

JOIN MyDatabase.dbo.Complaints C on C.ID = P.ID

where P.Email1 not like ''' + @TermToTweak + '''

AND C.DateBlocked IS NULL'') AT LinkedServer'

EXECUTE(@cmd)

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!