Comments
Sort by recent activity
Hello, You should be able to restrict suggestions for certain schema's in SQL Prompt Options by using Connections -> Specifiy the databases you want to load suggestions for: This should only load suggestions for the schema's you specify, and then load suggestions for the objects in those schemas. Here is our documentation on how to use this option: https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory#Managingconnectionsandmemory-ManagingdatabaseconnectionsManagingdatabaseconnections I hope this helps. Kind regards, / comments
Hello,You should be able to restrict suggestions for certain schema's in SQL Prompt Options by using Connections -> Specifiy the databases you want to load suggestions for:This should only load sug...
Hello, Thank you for your question regarding SQL Monitor. The requirements have changed between version 8 and version 9 of SQL Monitor. For your current version (v.8), you will need the following to monitor the host Windows Machine:
The account should be an administrator on the remote Windows host machine.
The account should have login rights locally on the machine where the base monitor is installed, so that SQL Monitor can authenticate the account.
This does not necessarily require you to use a domain admin, but the account will need local admin permissions. For version 9 of SQL Monitor, you can connect to a Windows Machine without using admin permissions. You can find those requirements here: https://documentation.red-gate.com/sm/getting-started/requirements/permissions#Permissions-MonitoringhostWindowsmachineswithoutadminpermissions I hope this helps! Kind regards, / comments
Hello,Thank you for your question regarding SQL Monitor. The requirements have changed between version 8 and version 9 of SQL Monitor. For your current version (v.8), you will need the following to...
Hello, Thank you for your question. We are currently checking on this to see if it is possible, however so far we do not believe it is. We will let you know as soon as we can find an answer. Kind regards, / comments
Hello,Thank you for your question. We are currently checking on this to see if it is possible, however so far we do not believe it is.We will let you know as soon as we can find an answer.Kind rega...
Hi Carmine, Thank you for your question regarding SQL Clone. I believe the script we have listed in our documentation should be able to achieve a refresh of all the clones linked to an image: https://documentation.red-gate.com/clone/automation/powershell-worked-examples/refresh-all-clone-databases-to-use-an-updated-image You would just want to automate a nightly image creation from Prod first, and then use the script on the newly created image. Looking into the script, it looks like it should keep the same database names for the clones. In addition, there is also an article on Scripting Custom SQL Server Clones: https://www.red-gate.com/hub/product-learning/sql-provision/scripting-custom-sql-server-clones-for-database-development-and-testing?product=sql-clone Can you please test these and let us know if it works for your set up. Kind regards, / comments
Hi Carmine,Thank you for your question regarding SQL Clone. I believe the script we have listed in our documentation should be able to achieve a refresh of all the clones linked to an image:https:/...
Hi, I am sorry to see you have run into this issue with installing SQL Prompt. Could I ask you to navigate to http://localhost:22221/redgate/status.html and look to see which version the Redgate Client is running on? It should show at the top of the page. After that, would you click Check for Service Updates at the bottom? This should update the Client Service to the latest version. Thank you and my apologies for the inconvenience. Kind regards, Thank you, Mac Frierson / comments
Hi,I am sorry to see you have run into this issue with installing SQL Prompt.Could I ask you to navigate to http://localhost:22221/redgate/status.html and look to see which version the Redgate Clie...