In addition to using the command line, batch file route, Another option would be using Powershell. DBAtools has a function for installing service packs and CUs that you may want...

Did you check the permissions on the files themselves (not the share)? When detatching files in SSMS, if you aren't running SSMS as administrator, the file permissions change to whoever...

Try setting a size for the @CoverType parameter. When you don't specify the size, it defaults to 1

Sue

Do a search on this: target server memory total server memory sql server

Then you'll know what it means and understand why Steve asked that. Also you can query the performance...

Did you check the full text logs in the log directory for any issues, errors?

Sue

The message is from a long checkpoint where it exceeds the recovery interval. If the memory looks fine then it's usually related to slow IO. In addition to the perf...

It won't happen due to permissions but it can happen when it can't find the object due to whatever database context - what database I am in when I run...

Change the stored procedure to use FOR XML instead of using this that you have in your code:

oCmd.Dialect = "{5D531CB2-E6Ed-11D2-B252-00C04F681B71}"

You can return XML data using FOR XML in queries, stored...

That would be correct. It is the service SIDs that I have mentioned a couple of times now. And those are listed as being in the sysadmins as they should....

After you set it up on the primary node, you need to do the same and set it up on all nodes in the cluster. You also need to use...

I don't see anything for services in your post but if you don't manually change the service accounts permissions and you set it up using SQL Server Configuration Manager (or...

The service account for SQL Server and SQL Agent aren't just members of the public service role and when you use SQL Server configuration manager to set the service accounts...

Testers? They got rid of testing but I read that recently added some back. Probably one of those two testers didn't have time.

But you are very welcome 🙂

I read about that error in one of the SQL Skills insider newsletters. Finally found the one that mentions it - It basically says its benign.  Refer to page 3...

I use management studio and right click the AG group and select Failover and when the wizard comes up I select the secondary replica i want to failover too,...