How can we help you today? How can we help you today?
squigley
Activity overview Badges (0) Posts (0) Comments (251)

Comments

Sort by recent activity
Hello Torsten, Thanks for your inquiry and sorry to hear about your issue with SQL Prompt. Can you confirm the version of SQL Server, SSMS, and SQL Prompt that you're using? Also what active style are you using when this happens? Thanks! / comments
  1. Community
  2. SQL Prompt
  3. column names in table DDL bug
Hello Torsten,Thanks for your inquiry and sorry to hear about your issue with SQL Prompt.Can you confirm the version of SQL Server, SSMS, and SQL Prompt that you're using?Also what active style are...
0 votes
Good Afternoon, Thanks for your inquiry with SQL Data Compare. Can you try the steps mentioned in the below documentation to see if that helps? https://documentation.red-gate.com/sdc/troubleshooting/unexpected-behavior-technical-questions/how-much-free-hard-disk-space-is-required Thanks! / comments
  1. Community
  2. SQL Data Compare
  3. Disk Space Issues With Migrations
Good Afternoon,Thanks for your inquiry with SQL Data Compare.Can you try the steps mentioned in the below documentation to see if that helps?https://documentation.red-gate.com/sdc/troubleshooting/u...
0 votes
Good Afternoon! Thanks for your inquiry with SQL Source Control. You should be able to find all of this information under the Setup Tab on the SQL Source Control GUI: [image] Please let me know if you have any other questions or concerns. Thanks! / comments
  1. Community
  2. SQL Source Control
  3. How do i see what repository my source control linked database is connected to?
Good Afternoon!Thanks for your inquiry with SQL Source Control.You should be able to find all of this information under the Setup Tab on the SQL Source Control GUI:Please let me know if you have an...
0 votes
Hello Peter, Thanks for your inquiry with SQL Monitor. Unfortunately this isn't something that is currently possible to do within the tool, I do apologize for the inconvenience that this brings. I would highly recommend creating a uservoice request so that the developers can see the demand for such a feature: https://sqlmonitor.uservoice.com/forums/91743-suggestions Please let me know if you have any other questions or concerns. Thanks! / comments
  1. Community
  2. Redgate Monitor
  3. Database name "like" filter for "Database Unavailable" alert?
Hello Peter,Thanks for your inquiry with SQL Monitor.Unfortunately this isn't something that is currently possible to do within the tool, I do apologize for the inconvenience that this brings. I wo...
0 votes
Good Morning! I was able to get the following recommendations. You should first run DBCC CHECKTABLE to figure out if it's even recoverable. While that's running, you should also look in the Windows Event Viewer to determine if your storage is failing. Can you let me know of your results for the above? Thanks! / comments
  1. Community
  2. Redgate Monitor
  3. Corrupt index after removing a server from monitoring?
Good Morning!I was able to get the following recommendations.You should first run DBCC CHECKTABLE to figure out if it's even recoverable. While that's running, you should also look in the Windows E...
0 votes
Good Afternoon! Thanks for your inquiry with SQL Monitor. I believe doing a rebuild should work, but I want to double check first before suggesting it. I'll update you once I know more. / comments
  1. Community
  2. Redgate Monitor
  3. Corrupt index after removing a server from monitoring?
Good Afternoon!Thanks for your inquiry with SQL Monitor.I believe doing a rebuild should work, but I want to double check first before suggesting it.I'll update you once I know more.
0 votes
Hello Stephen, Thanks for confirming. Can you try upgrading to the latest version below and let me know if that helps? Download Link: https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_11.1.6.8971.exe Upgrade Documentation: https://documentation.red-gate.com/sm/maintaining-and-upgrading-sql-monitor/upgrading-sql-monitor / comments
  1. Community
  2. Redgate Monitor
  3. How can I fix internal SQL Monitor Error for event QueryWaitStatsSampler?
Hello Stephen,Thanks for confirming.Can you try upgrading to the latest version below and let me know if that helps?Download Link: https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMon...
0 votes
Hello Stephen, Thanks for your inquiry and sorry to hear about your issue with SQL Monitor. Can you confirm the exact version of SQL Monitor 11 that you're using from the Configuration>Abouts page? I ask because the issue you're mentioning looks like one that was fixed in later versions of the tool. / comments
  1. Community
  2. Redgate Monitor
  3. How can I fix internal SQL Monitor Error for event QueryWaitStatsSampler?
Hello Stephen,Thanks for your inquiry and sorry to hear about your issue with SQL Monitor.Can you confirm the exact version of SQL Monitor 11 that you're using from the Configuration>Abouts page? ...
0 votes
Hello Ben, Thanks for your patience with this as I've been able to replicate this and discuss it with my team. Ultimately the conclusion we've gathered is that what you're seeing is expected behavior for the tool which is just highlighting textual differences and I'll explain below why that is the case: Textual differences are just differences in the text shown  - so in this case the (C3,C4) vs (C4,C3) ​.  They are not necessarily semantic differences (and in this example it is not a semantic difference, because the order of those columns doesn't make it a different object or change its function). A semantic difference is one that indicates the objects are actually different in function or definition in some way, like say a column being an int in one table and a bigint in another table. The object should only show up in the top view as different if there is a difference (of either sort) that is not being ignored.  However, as soon as there is one difference causing it to appear in the top pane as having a difference in the objects (or you find it in the identical objects category), the bottom pane, when SQL View is selected, will show ALL textual differences.  The Summary view should only show semantic differences when it is selected.​ So what you are seeing when the object is identical but it shows textual differences highlighted is that there are differences that are being ignored (in this case the column order) but since that pane is only showing textual differences it always highlights them. When an object is identical, it won't attempt to be deployed, so those differences are not deployed, but if an object shows up as having a difference (for a reason that is not being ignored) then when it is deployed, all of the textual differences will be deployed along with the actual difference that caused it to show up as having a difference. Thanks! / comments
  1. Community
  2. SQL Data Compare
  3. Can you ignore Index Include Column order?
Hello Ben,Thanks for your patience with this as I've been able to replicate this and discuss it with my team.Ultimately the conclusion we've gathered is that what you're seeing is expected behavi...
0 votes
Good Afternoon, Thanks for your inquiry and sorry to hear about your issue with SQL Monitor. Can you confirm what version and entity type are involved in the above error message? / comments
  1. Community
  2. Redgate Monitor
  3. Internal SQL Monitor error
Good Afternoon,Thanks for your inquiry and sorry to hear about your issue with SQL Monitor.Can you confirm what version and entity type are involved in the above error message?
0 votes
Total activity
433
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
182