Comments
Sort by recent activity
[image] Your secret is safe with us. Glad you found the culprit and were able to resolve the issue. Thank you for posting up and sharing the details. / comments
Your secret is safe with us.Glad you found the culprit and were able to resolve the issue.Thank you for posting up and sharing the details.
Hi, thank you for reaching out regarding this concern. If possible can you share your script so we can help investigate this issue? To start looking into this we'd like to verify the script just to verify there isn't a scripting issue which we can help rectify quickly. Are you able to also verify that the database is configured for Windows authentication and that the user you are trying to log into the database with has appropriate access permissions? / comments
Hi, thank you for reaching out regarding this concern. If possible can you share your script so we can help investigate this issue?To start looking into this we'd like to verify the script just to ...
Hi rohitkashyap89 Thanks for reaching out and providing the error message details. Can I recommend this page to see if it helps with your issue? Error 80070002 - The Add-in SQL Prompt failed to load or caused an exception If you still continue to have the error and have a support agreement with Redgate please log a ticket through our product support site so we can assist further. / comments
Hi rohitkashyap89Thanks for reaching out and providing the error message details.Can I recommend this page to see if it helps with your issue?Error 80070002 - The Add-in SQL Prompt failed to load o...
Hi there, Thanks for reaching out to the Redgate Forums and sorry to hear about this pop-up issue with SQL Prompt and the licence management. This pop-up error does occur from time to time and it's not always clear on the cause. In a number of cases, it's due to strict browser security preventing the opening of new windows - specifically within Internet Explorer There is a work-around that could help in this instance: Open the product you want to activateNavigate to http://localhost:22221/redgate/status.htmlNext to the entry for that product, click Activate Here.Then over the 'Log in' button, right-click and copy the link locationPaste it into notepad and remove &openinbrowser=true from the endPaste that URL into a browser window to complete your login / comments
Hi there,Thanks for reaching out to the Redgate Forums and sorry to hear about this pop-up issue with SQL Prompt and the licence management.This pop-up error does occur from time to time and it's n...
Hi there, Thank you for reaching out on the Redgate Forums and asking about some performance concerns with SQL Monitor. Are you able to provide some more insight into how you have SQL Monitor setup, Are you using the MI as a data repo / monitored environment - or both? Can you please confirm the resources usage by SQL Monitor? I don't believe we have actual guideline values for Azure MI but we do have some details around Azure SQL & elastic pools which can be viewed at the link below SQL Monitor Infrastructure - hardware & performance guidelines Can you review and verify that your system hardware meets the recommendations? / comments
Hi there,Thank you for reaching out on the Redgate Forums and asking about some performance concerns with SQL Monitor.Are you able to provide some more insight into how you have SQL Monitor setup, ...
Hi, Thank you for posting on our community forums, I understand your request is to de-select specific columns from a bulk amount of columns within various tables so they are not compared between databases. Whilst there isn't a bulk way within SQL Compare that can assist with this, it may be possible to edit the project file directly. This would take slightly longer than manually un-selecting columns/tables in the program directly but would be potentially helpful if you are planning to re-use the project file multiple times. When you create a project in SQL Compare you can save it as a .SDC file. This file can be edited in a text editor and has an XML-format layout. Within the TableActions node, it is possible to add commands to de-select columns. You would need to enter in each TableName & ColumnName record, save the file and then open the project in SQL Compare. As an example below, I have Deselected Columns 'DBVersion' from tableA & 'DatabaseLogID' from tableB: <TableActions type="ArrayList" version="1"> <value version="1" type="SelectTableEvent"> <action>DeselectColumn</action> <ColumnName>DBVersion:DBVersion</ColumnName> <TableName>[dbo].[tableA]:[dbo].[tableA]</TableName> </value> <value version="1" type="SelectTableEvent"> <action>DeselectColumn</action> <ColumnName>DatabaseLogID:DatabaseLogID</ColumnName> <TableName>[dbo].[tableB]:[dbo].[tableB]</TableName> </value> </TableActions> This is a workaround and may require some testing in your environment to see if it can work for you. / comments
Hi, Thank you for posting on our community forums,I understand your request is to de-select specific columns from a bulk amount of columns within various tables so they are not compared between dat...
Looking like a move forward, thanks for the details and looks like you have a bit of a workaround to get moving. I will work with our team to replicate the logic you have in place and see how those sub/nested AND statements are functioning and verify your statement about it not applying to users/roles/schemas. / comments
Looking like a move forward, thanks for the details and looks like you have a bit of a workaround to get moving.I will work with our team to replicate the logic you have in place and see how those ...
Hi there, Thanks for reaching out on the Redgate Forums and sorry to hear you are having issues with SQL Source Control First thoughts are perhaps the roles have been filtered out to not appear in Commit & Get Latest tabs. Can you please check the following: SQL Source Control Setup > Edit filter rules > Role Is it enabled? Are there any exclusions configured that may be leading to the behaviour you are experiencing [image] If the Role object type is enabled and there are no exceptions, the next step would be to compare the database & repository. It would need an SQL Compare snapshot of the database & a zipped copy of the repository. Use SQL Compare to compare the snapshot of your live dB against the copy of the repo to see if the Roles do appear. That would help start to isolate the location of the issue; specific to SQL Compare or to some of your own settings/filters. Please reply to this post after checking the roles and we can assist further. / comments
Hi there,Thanks for reaching out on the Redgate Forums and sorry to hear you are having issues with SQL Source ControlFirst thoughts are perhaps the roles have been filtered out to not appear in Co...