Sproc to upd tbl in a different server

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Garadin One Orange Chip Points: 29613 More actions · Answer 1

Assuming you are using linked servers, you should just be able to replace:

Update Mytable

Set Myfield = MyData

FROM Mytable

WHERE MyCriteria = Something

With

Update Server2.Database2.dbo.MyTable

Set Myfield = MyData

FROM Server2.Database2.dbo.MyTable

WHERE MyCriteria = Something

You don't actually need the FROM if you aren't using any joins, but I'm used to putting it regardless.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 2

If you are using linked servers, make sure you have RPC enabled on the linked server and you can perform the following:

Execute serverb.databaseb.schemab.procedure;

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll