Viewing 5 posts - 1 through 5 (of 5 total)
Hi Frank,
nice article explaining how simple it is to query SQL Server by using PowerShell. Thank you!
If you just need to see data from multiple instances as one 'table' you...
August 4, 2020 at 2:10 pm
I prefer to split notifications for Agent restarts and Instance restarts => someone may restart instance and forget to restart Agent
Solution:
Agent restarts: with job as described
June 23, 2018 at 5:01 am
Sorry - I disagree with the "correct" answer!
If you modify records that will violate the WHERE-condition, the UPDATE-query will terminate with error msg 550
September 15, 2016 at 2:00 am
I face the same problem:
sp_cycle_agent_errorlog works fine some time and then it stops.
This occours on any configuration (SQL 2008, 2012, clustered, non-clustered, ...)
The cause is as you described: SQL Agent...
July 25, 2016 at 1:35 am
Hello,
we sometimes find the same problem. The SQL Agent holds a file lock on sqlagent.out and doesn't realease it when calling sp_cycle_agent_errorlog. So the Agent locks itself.
Solution: Restart the Agent...
July 15, 2016 at 12:43 am
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy