Posts
Sort by recent activity
Long Running Query Alert
What is the length of time a query has to run before the long running query alert is triggered?Thanks.
SQL Prompt not showing in SSMS v18.1
I have been using SQL Prompt with SSMS v17 for a while and now installed v18.1 however SQL Prompt is not showing in the menu or toolbar. Do I need to reinstall SQL Prompt? I am using 9.5.7.10212 an...
Email notifications are failing - but they are not
I have recent started using email alerts for deadlocks, long running processes etc for a database. They are being generated and I am getting email ok. However, I am now seeing the following notific...
SQL Clone Agent "does not have 'change permissions' access for directory path"
When creating an image I am getting the following error message straightaway:The agent's Windows account <agentservicename> does not have 'change permissions' access for directory path '\\<serverna...
Cannot upgrading SQL Monitor getting "Port is not available"
Trying to upgrade SQL Monitor and in the installation options I cannot get past the screen where you click to test the web server port. The web server port number is 8080 and when I click on Test I...
Add alerts to the server overview graph
Currently the graph on the overview will show coloured dots on the x axis of the graph. For example I will be able to see over the last 3 hours how many alerts for "Long running queries" or "Job Du...
Spam email from Tony Payne?
Just received this email from Tony Payne at Redgate which does not look legitimate to me. The text in bold were links to an external website which I have removed from the message. Has anyone else h...
How to change recovery mode of an image or clone
Production database uses FULL recovery mode but I want the image to use SIMPLE. I know how to run a TSQL script to do this however I tried this as a modification but I get the following error at th...
Clone size increased a lot
I have created a database image which is 134GB. Then I created a clone of that image which was 100MB, which is a great disk saver. However I ran a SELECT statement to pull out 1000 rows then the da...
Error modifying image during creation -
I am running a modification script during an image creation however the script needs to drop tables in the database. When the image creation process gets to the end it generates this error:An excep...