There is an environment variable PSModulePath that should be pointing to whatever location has the folder structure: PowerShell\Modules\SQLPS

I'd check your environment variable and check for the location of the SQLPS...

I hope that's it - thanks a lot for posting back! Please post back if it rears it's ugly head again. It would be good to know if this was...

Thanks for posting back. It definitely seemed like something not right with the account - glad it's all working now.

Sue

Auto update stats may not be executing often enough due to the size of the tables. There is a trace flag that could help your situation on SQL Server 2014....

It would be in the default trace, depending on how far back you have trace files. Otherwise, yes you would want to use a DDL trigger at the server level...

I think the alternate path needs a backslash added at the end. Otherwise, you may want to try doing it from the command line. This article has a walk through...

Yes you can use it in 2017. You need to get the RBS.msi from the SQL Server 2017 feature pack. I think it may also be on the installation media....

Did you check the owner of the jobs? Make sure the password isn't expired for the service account, the account isn't disabled or locked out and if nothing else, try...

The service account for SSRS does not need to be a sysadmin so you would want to remove that. Usually the permissions get out of sorts when you don't use...

Replication task and Integration Services package job step logging is handled by their respective subsystem. You cannot use SQL Server Agent to configure jog step logging for these types...

You may want to look at the wait stats and see where things are taking time. The query in this posts includes links to the waits library on SQL Skills...

You would probably want to create a calendar table when you also want to exclude bank and national holidays since those can vary by country, company and whatever...

You would probably want to create a calendar table when you also want to exclude bank and national holidays since those can vary by country, company and whatever else. These...

Thanks

Does it store these states anywhere though?

I am using unit tests, specifically negative unit tests (trip the catch part of an SP)

The unit test code has been editted to...

After adding the listener in cluster manager, you need to execute: alter availability group...alter listener... to add the port for the listener. You can check if it has a port...