Viewing 2 posts - 1 through 2 (of 2 total)
Ok thanks. Will look at that.
But as I said, RaiseError severity 16 never used to report errors in the SQL Agent, now it is with the message
"[516] Step 1 for...
July 13, 2023 at 4:17 am
#4233817
That is what we are doing
/* allow a normal or a primary replica database through */
IF ISNULL(sys.fn_hadr_is_primary_replica('ReportServer' ),1) != 1 BEGIN RAISERROR(' %s is not primary replica for %s',16,1, @@Servername,...
July 12, 2023 at 2:25 am
#4232856