SQL Server Insert into linked server

Question

In a procedure I control errors with TRY CATCH, but in an insert into linked server not runs for handling this errors, because try catch not run.

How I can handling this errors?

Example:

insert into linkedserver.database.dbo.table values ('value1','value2')

If the server isoffline I have error of connection of the SQLCLI and cannot control this error for insert in local when the linked server are offline for after when the server return to online status put the data in the remote server with another procedure.

Thanks

Jorge

You talk about "when the server return to online status" - why not build a solution that always assumes that the server is unavailable right now, and applies the change when the server is available. Something like Service Broker would handle this, and you'd no longer have any dependency on the remote server. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Sep 27, 2012 at 10:43
Please be aware that tags stand alone. That is, selecting the tags linked and server doesn't mean you're talking about the linked server feature in SQL Server. — Charles
– Charles, Commented Sep 27, 2012 at 16:51

Diego · Accepted Answer · 2012-09-27 10:33:57Z

1

if you wrap your code into a EXEC statment you will have access to the error.

like exec( 'insert into....')

answered Sep 27, 2012 at 10:33

Diego

36.4k21 gold badges94 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server Insert into linked server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related