Hi all, I have 2 linked servers and have made a trigger that updates the data in a particular table in server B every time an insert is done in Server A, now my problem is that server B may not be available at the moment of making the changes to the data and wonder if there's a way to know if it's available or not.
I know this sounds a lot like replication but these are both SQL Server Express servers and replication publishing is not allow.
TIA,
Enmanuel
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain