Brian, thank you for the detailed answer. If I have 50 reports, do I need to manually export each individual  one, so I have a backup...and once I install SSRS...

@jeffrey Williams...excellent answer, thank you !

@Ant Green, thank you

@jeff B...no, snapshot would not be the ticket, as we need dynamic data to be reported on, but thank you...

That worked, Vielen Dank !

Cool, thanks for the follow up.

Attached is what I mean by Core Cluster Resources, highlighted in yellow...you do this in Failover Cluster Manager.

My problem was that host (Core Cluster Resources) was on Server A, but...

I never found my answer of which server is actually the active one, but I was able to patch by doing this;

Manually fail over the active role on Server B...

Thank you everybody. I will play around with a staging table and some other ideas !

Thanks Jeffrey. One question: why even have step 2 ? Cant you just have the stored procedure get data from original source ? If a network error occurs, a rollback...

Hmm, not sure what you mean by structure, but it's very simple: Its a data flow task in SSIS, where all columns in Table A are populated from Table B...

Yes, I can connect via my laptop, after setting up Larry alias on my laptop. I have configuration manager and SSMS on my laptop.

But how can I have an app...

Perfect, thank you!

that helps, thank you very much everybody !

Thanks guys...I like that merge function, and I will read up a bit more.

Overall, I only want this trigger to fire when a row is added or a row is...

Thank you MM, that did the trick...but could you please expand what you meant with INSERTED virtual table function ?

Doesnt my trigger now only update future rows in Table B,...

Thanks everybody for chiming in...I finally got it to work by this;

Created the view

Went to the view/properties/permissions/ in SMS..find the user that you want to have access...then choose grant for...