I made a table with a trigger the update trigger

Main content is the updated number to insert a link to another server instance,

But if another link to the server is unavailable, will cause the failure of the operation of the update itself,
I do not know what is the way,
Thanks for calling eldest brother grant instruction!

CodePudding user response:

Using OPENROWSET (' provider_name '
, {' datasource '; 'user_id'; 'password'
| 'provider_string}
, {[catalog.] [schema.] object
| 'query'}
)

Try using this.