I would like to write a connection, sub, function, object maybe? Anyway, I'd like to be able to set a primary and secondary SQL server. Connect to the primary if it can, if not, connect to secondary. Also, if during operation, the primary goes down, I'd like to raise an event, prompt user to connect to secondary, then if primary comes back up, reconnect to primary and sync.
I know this is a lot to ask for, I guess I'm just looking for ideas on how to raise such events. never really done any kind of object like that. Only simple user controls.
Anyone have any thoughts? Impossible? Too hard? Perhaps just a tool someone else has made and I can get?