Comments
Sort by recent activity
SQL Cover uses extended events so I would guess that you would need the ALTER ANY EVENT SESSION permission in order to create/drop the event session and then start/stop the trace. SQL Cover doesn't list the minimum permissions so it might be a case of trial and error. / comments
SQL Cover uses extended events so I would guess that you would need the ALTER ANY EVENT SESSION permission in order to create/drop the event session and then start/stop the trace. SQL Cover doesn't...
Hi delapohl It looks like something has gone awry with the mappings. Are the 16 tables all part of the same schema? If so you may need to check the owner mappings - https://documentation.red-gate.com/display/SC13/Mapping+owners - and ensure that they are mapped correctly. / comments
Hi delapohl It looks like something has gone awry with the mappings. Are the 16 tables all part of the same schema? If so you may need to check the owner mappings - https://documentation.red-gate.c...
Is the Redgate toolbar hiding somewhere like this? - [image] If you can see it checked when you right click on the toolbar then SSMS may have decided to add it into a gap that is too small for any of the buttons to be visible. One thing you could also try is to disable the other toolbars to verify that the Redgate toolbar becomes visible. Once you know where it is, you can drag it to a new row so that it can fully expand. / comments
Is the Redgate toolbar hiding somewhere like this? - If you can see it checked when you right click on the toolbar then SSMS may have decided to add it into a gap that is too small for any of the b...
You're right @DanW564, that's exactly what the problem is and the workaround is just to add the missing comma as you've explained. We've got a fix ready for this and it should go out in the next frequent update release. / comments
You're right @DanW564, that's exactly what the problem is and the workaround is just to add the missing comma as you've explained.We've got a fix ready for this and it should go out in the next fre...
Hi @Gooders Sorry, SQL Search doesn't index partition schemes. For more info on its limitations, see the "Search limitations" section on the How to search page in the online documentation. / comments
Hi @Gooders Sorry, SQL Search doesn't index partition schemes. For more info on its limitations, see the "Search limitations" section on the How to search page in the online documentation.
Hi @swallman, There are certainly ways of achieving this. If you're performing a scheduled restore then there will be a SQL Server Agent job for the restore - if you add some extra steps to it with your custom scripts then they will be executed immediately afterwards. If you're performing on-demand restores, then it needs slightly more thought. One option could be to use SQL Backup's extended stored procedure and create a SQL script that both performs the backup and tweaks the data afterwards. This could be a stored procedure somewhere on the server, or stored locally and run via sqlcmd for instance. We have a page on scripting SQL Backup that may be of interest - https://documentation.red-gate.com/sbu9/scripting-sql-backup-pro I hope this helps. / comments
Hi @swallman,There are certainly ways of achieving this. If you're performing a scheduled restore then there will be a SQL Server Agent job for the restore - if you add some extra steps to it with ...
Hi @bhmsch 1. There isn't a way to do this. Sorry. 2. If you want to provide feedback on SQL Compare then please leave any suggestions on our Uservoice site. All the best. / comments
Hi @bhmsch 1. There isn't a way to do this. Sorry.2. If you want to provide feedback on SQL Compare then please leave any suggestions on our Uservoice site.All the best.
Hi @kalo It seems that SQL Source Control has its own diff viewer so any changes to the one in SQL Compare shouldn't affect SQL Source Control. / comments
Hi @kalo It seems that SQL Source Control has its own diff viewer so any changes to the one in SQL Compare shouldn't affect SQL Source Control.
That's really interesting, thanks very much for sharing that. When you say "recalculation", are you referring to the recalculation that is done after the deployment? If so, you can turn that off in the deployment wizard - see below.[image] The ideal scenario sounds like it would be to make it easier for you to deploy. We're aware that there are some issues around the current implementation of selecting dependencies - at the moment it's a binary all or nothing choice. If you could choose whether or not to deploy individual dependencies, it sounds like that would improve things for you. To be honest, I'm not certain about SQL Source Control's diff viewer. I don't think it's shared with SQL Compare, but I'll look into it. / comments
That's really interesting, thanks very much for sharing that.When you say "recalculation", are you referring to the recalculation that is done after the deployment? If so, you can turn that off in ...
The fix went out this morning with the 13.4.4.6883 release. / comments
The fix went out this morning with the 13.4.4.6883 release.