Hello,

If domain permissions are the issue then this might help https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server?view=sql-server-2017

It's listed as 2017 but, as far as I know, it's the same for 2016. Apologises if you've already seen...

I have never done this so can't directly advise but this might help https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-2017 ?

Hello,

Sorry for not replying. I got distracted by some other issues and I've also been trying to answer a further question myself but unfortunately I've not succeeded. Currently...

Hello,

Thanks for your reply, The application, that I intend this account to be used for, opens the master key to decrypt data with a certificate. From memory I...

I'm still looking at it but possibly something like this?:

It creates a temporary as follows:

It takes the first row from tabDemo and the first set in...

Hello,

Thank you. That gives me the result I need.

Thanks

Hello,

Sorry for my slow reply. Thanks for the information.

Are both the working and not working VM's on the same physical host? You've probably already checked but I'm wondering if it could be fault on the host affecting the...

Hello,

Thanks for your help. I'd thought before that the amount of fragmentation seemed high but wasn't sure. I'll try and do some research of my own but would also...

Hello,

Thanks for your help. Sorry I don't recognise the abbreviation BASF?

My maintenance plan (runs weekly) is currently set to:

reindex if fragmentation is above 15%...

Hello,

Thanks for your help. The statement for the largest table is here:

USE [CSSystem]

Hello,

Thanks for your help. I will have a look at that functionality.

Thanks for the advice on moving large tables. The largest is only about 5000 rows....

Hello,

Apologises. I should have posted code. It's just SSMS generated code altered to specify the new file group: