Comments
Sort by recent activity
So tough to pick a favorite, any where I learn something new, Kendra's Git for DB code was excellent, as a noob to using Git, any learning I can pick up is a bonus... / comments
So tough to pick a favorite, any where I learn something new, Kendra's Git for DB code was excellent, as a noob to using Git, any learning I can pick up is a bonus...
What do you want to achieve at work in 2020? This year I want to learn as much as possible about the non db engine products supplied with SQL Server, AS, IS, RS etc. Plus as much Azure info as I can soak in. Need to expand my product knowledge as a DBA. / comments
What do you want to achieve at work in 2020?This year I want to learn as much as possible about the non db engine products supplied with SQL Server, AS, IS, RS etc. Plus as much Azure info as I can...
Have you tried just the BACKUP DATABASE text without the brackets? / comments
Have you tried just the BACKUP DATABASE text without the brackets?
Try with just BACKUP DATABASE. If that fails, wait for Redgate Support to help? / comments
Try with just BACKUP DATABASE. If that fails, wait for Redgate Support to help?
Listing several object names in the "Exclude queries that contain SQL commands or objects matching the following regular expressions" section worked for me. In one database we have the following listed:
(Directly copied - note no white space, commas etc, just separate lines for each expression).
Stage.HelperFactStudentCourseSummaryFinal
Stage.HelperFactCourseItemActivitySource
Stage.HelperFactCourseItemActivityFinal
Stage.HelperFactSubmissionFinal
Maybe the square brackets need to be escaped?
"Special characters need to be escaped e.g . $ ^ { [ ( ) ] } * + ? |" / comments
Listing several object names in the "Exclude queries that contain SQL commands or objects matching the following regular expressions" section worked for me. In one database we have the following li...
Thanks Adam... I missed the help icon... :oops: / comments
Thanks Adam... I missed the help icon... :oops:
Thanks Markus. There is a URL in there, but not fully qualified. I've edited it, and set a report to post at 11:00AM... Wait and see...
No luck, still no emails.... Think I'll have to log a support call to get this fixed.... / comments
Thanks Markus. There is a URL in there, but not fully qualified. I've edited it, and set a report to post at 11:00AM... Wait and see...
No luck, still no emails.... Think I'll have to log a support...
It looks a great feature, I cannot for the life of me get it to email a report though. Gawd knows where I'm going wrong... Email seems to be configured properly, all alerts get emailed, but setting a report to send gives no results. Anybody else having issues with emailing a report? / comments
It looks a great feature, I cannot for the life of me get it to email a report though. Gawd knows where I'm going wrong... Email seems to be configured properly, all alerts get emailed, but setting...
Thanks Frank.
Redgate did provide me with a workaround yesterday, which fixes the issue, if you are happy to live without the db integrity check alert.
Not sure we want to give sysadmin to a monitoring user - we use a least privilege principle, a monitoring account shouldn't need sysadmin. / comments
Thanks Frank.
Redgate did provide me with a workaround yesterday, which fixes the issue, if you are happy to live without the db integrity check alert.
Not sure we want to give sysadmin to a monito...
Did this get fixed?
We've just purchased the product, and upgraded at the same time, to find all the SQL monitoring has stopped.
We really don't want to give the monitoring account sysadmin, that's a backwards step? / comments
Did this get fixed?
We've just purchased the product, and upgraded at the same time, to find all the SQL monitoring has stopped.
We really don't want to give the monitoring account sysadmin, that's...