July 18, 2008 at 8:04 am
We have a JOB that runs every day on certain time, it reads Table data and based on that it updates our Production Server and there are triggers on that Table which updates other servers.
We setup up MS DTC Services to run queries directly (INSERT, UPDATE OR DELETE) from triggers activity.
The Job's Stored procedure when updates our production Table we setup Triggers that updates changes to other servers. Problem occurs when a Linked Server Failed, meaning it becomes un available due to network issue or if its physically down. Now our triggers are failing to accept changes including proudction table. The job that send changes on our production table is giving following error:
Executed as user: NT AUTHORITY\SYSTEM. SQL Server does not exist or access denied. [SQLSTATE 42000] (Error 17) 139641541 [SQLSTATE 01000] (Error 0). The step failed.
I would like to know if there is any way that production Table may grab/accept all changes (INSERT, UPDATE AND DELETE), but if the other servers are not not available it does not matter. if they are available then it work as usual.
If some one has faced this issue plz. help me how to fix this problem, we wrote trigger on INSERT UPDATE AND DELETE, so if insert occurs on Production it may send insert to other server, but if not avaialable it does not matter. same for update and delete. How it would be done?
Shamshad Ali.
July 18, 2008 at 8:07 am
Duplicate post. Original here
Please do not cross post.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply