Activity overview
Latest activity by joejf
I just installed SQL Compare 13. It just seemed like a strange bug especially since the button still works.
I cannot speak to the usefulness but the Summary View for Views would be very similar to Procedures. They both show differences in permissions and extended properties. Procedures additionally show EXECUTE AS and settings like ANSI_NULLS. [image] / comments
I just installed SQL Compare 13. It just seemed like a strange bug especially since the button still works.
I cannot speak to the usefulness but the Summary View for Views would be very similar to...
SQL Compare 13 Summary View Button "Missing" For Procedures and Functions
The button is actually there and works fine. But, there is no text on the button when the compared object is a Stored Procedure or a Function. The button is fine for other object types.
After some experimentation it looks like setting those options in the GUI creates a file in the root of the scripts folder, RedGateDatabaseInfo.xml. As long as this file exists in the root of the scripts folder the command line version will use it. / comments
After some experimentation it looks like setting those options in the GUI creates a file in the root of the scripts folder, RedGateDatabaseInfo.xml. As long as this file exists in the root of the s...
"Comparison settings for scripts folder" from command line?
When using a Scripts folder as in a comparison there is a place to change "Comparison settings for scripts folder". In this dialog you can change the Default collation and SQL Server version.
How c...
I have not tried plain old batch commands. The best way to accomplish this is using the print output of the default change as the input of the new change and replace the description placeholder. Powershell was the quickest way to test this inline replace. But, I think this exercise did prove that it can be done with the CommandLineHooks.xml file. I may look into this more in the next few weeks. / comments
I have not tried plain old batch commands. The best way to accomplish this is using the print output of the default change as the input of the new change and replace the description placeholder. Po...
Thanks datacentricity.
Something else I toyed with today is modifying CommandLineHooks.xml to convert the default changelist to a pending changelist for the commit command (instead of actually committing). I tried this with powershell for a quick test. This works but for some reason the powershell.exe process is not ending and I have to cancel the commit. But, before cancelling I can see in my Perforce client that the new changelist has been created with the correct files.
I think this approach could work.
<CommandLine>powershell -Command "p4 change -o | ForEach-Object { $_ -replace \"^<enter description here^>\", \"($Message)\" } | p4 change -i; exit"</CommandLine> / comments
Thanks datacentricity.
Something else I toyed with today is modifying CommandLineHooks.xml to convert the default changelist to a pending changelist for the commit command (instead of actually comm...
Access to files for uncommitted changes
Is there any way to get access to the new or updated file for uncommitted changes?
In our company we peer review SQL code before submitting to version control (Perforce). Does anyone know of a way ...
Catherine Kearns wrote:
Apologies if I’ve misunderstood your additional comments, but did you know that it is possible to configure the six database-specific alerts at the database level?
Yes, I knew about the database specific alerts. The problem is that deadlocks are not database specific. So, filtering is a must. Thanks for the quick response.
Joe / comments
Catherine Kearns wrote:
Apologies if I’ve misunderstood your additional comments, but did you know that it is possible to configure the six database-specific alerts at the database level?
Ye...
I just want to support the enhancement request for filtering of deadlock alerts. We also have 3rd party applications that encounter a lot of deadlocks. The databases for these 3rd party applications run on our production SQL Server, which also houses our in house SQL development. I need to be able to get alerts on deadlocks occurring in our own applications and not have them lost in all of the deadlocks from 3rd party applications. One of the things I was really looking forward to in SQL Monitor was the ability to configure alerts on a database level. It makes sense that deadlocks are reported at an instance level. So, filtering is a must have! / comments
I just want to support the enhancement request for filtering of deadlock alerts. We also have 3rd party applications that encounter a lot of deadlocks. The databases for these 3rd party application...
I apologize for duplicating some existing issues but thank you for your detailed responses.
Comment-Clear. I suggested adding a check box to clear alerts when adding a comment based on the current UI design. In SQL Response when you wanted to clear alerts you were required to comment. That was annoying at times but I would like the ability to add a comment when clearing alerts in one step. Since there is already a popup when adding a comment that seems like a good place to add a check box to also clear the alerts.
Alerts-Tabs. I tested this in both Firefox and IE 8. Basically, the current implementation does not allow the browser to handle opening an alert natively. I would like to see a regular link somewhere on the alert row that would let the browser handle the behavior natively.
Thanks again, Joe
[/quote] / comments
I apologize for duplicating some existing issues but thank you for your detailed responses.
Comment-Clear. I suggested adding a check box to clear alerts when adding a comment based on the current ...