I saw a note to try:  sp_replrestart here: https://www.sqlservercentral.com/forums/topic/the-process-could-not-execute-sp_repldonesp_replcounters

Also: https://repltalk.com/2010/02/19/the-process-could-not-execute-sp_repldonesp_replcounters/

First, SQL Server doesn't do anything with prompting. That's SSMS or your IDE. Everything submitted to the SQL Server instance is code. If you are in SSMS and use the...

Not in query analyzer. Might have been in Enterprise Manager, but I can't remember.

Have not used this in a long time, but examples don't show quotes: https://learn.microsoft.com/en-us/sql/tools/ssbdiagnose/ssbdiagnose-utility-service-broker?view=sql-server-ver16#examples

SSIS doesn't do a great job of logging by default.

These might help:

• https://stackoverflow.com/questions/23962767/ssis-script-component-or-script-task-write-to-job-history-log
• https://www.sqlservercentral.com/forums/topic/job-history-logging-for-ssis-pkg-jobs

I haven't ever used registered servers much, but I can see how I might use this in a larger environment, especially the grouping. In today's cloud world, this could be...

I'm not a system administrator, so forgive me for not understanding the nuances of why some servers would be down days after the fact.

According the Microsoft: https://support.microsoft.com/en-us/topic/kb5042421-crowdstrike-issue-impacting-windows-endpoints-causing-an-0x50-or-0x7e-error-message-on-a-blue-screen-b1c700e0-7317-4e95-aeee-5d67dd35b92f

If fixing...

I assume SQL 2019 for David, but I do think it's hard to regression test. I don't know how many of us have a decent set of things to test...

Sorry, typo. Meant to include the proc name in the question. Points awarded back

As I understand it, this...

IT often gets compared negatively with physical engineering, but we should remember that people have had centuries more practice at buildings, bridges, etc. yet we still have tragedies like...

...

As a bonus for the 'quick turnaround', one of the co-owners/vice president of the company gave me two weeks paid time off and round-trip tickets for my wife and...

Not well tested and not deployed in rings. Basic failures of software development.

Daniel, send a PM to SQLDCH with your Yahoo ID so he can invite you

Daniel, send a PM to SQLDCH with your Yahoo ID so he can invite you