Comments
Sort by recent activity
@jjj, have you reported this to support@red-gate.com? / comments
@jjj, have you reported this to support@red-gate.com?
@Yev, you may want to post this on SQL Prompt's UserVoice. Here's the link: https://redgate.uservoice.com/forums/94413-sql-prompt / comments
@Yev, you may want to post this on SQL Prompt's UserVoice. Here's the link: https://redgate.uservoice.com/forums/94413-sql-prompt
There really isn't a way to accomplish this that I know of in SQL Source Control. However, if you have SQL Compare and/or SQL Data Compare, you can use the Command Line tool to compare between your source and target and export a report file of the objects that are changing. / comments
There really isn't a way to accomplish this that I know of in SQL Source Control. However, if you have SQL Compare and/or SQL Data Compare, you can use the Command Line tool to compare between you...
Yes, you can do this in the Options screen of the Project you setup. There is an option to 'Ignore DML triggers' I do not see an option for ignoring DDL triggers though, but maybe DML is all you need? / comments
Yes, you can do this in the Options screen of the Project you setup. There is an option to 'Ignore DML triggers' I do not see an option for ignoring DDL triggers though, but maybe DML is all you ...
Thanks @RichardL [image] [image] / comments
Thanks @RichardL
Thanks @way0utwest!
Yes, the projects are broken up into environments and in one environment I might be in one phase and in another environment I might be in another phase. I could keep everything in one instance and use tab coloring, but I would have so many tabs open that it becomes a mess to keep organized. There are at least 4-5 different suggestions that have been posted in SQL Prompt's UserVoice, but none of them appear to be getting much attention from Red Gate. https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/5724478-improved-tab-navigation https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/1773091-better-tab-management https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/13969344-show-part-of-the-sql-text-on-the-tabs-hint https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/6681088-rename-open-tabs https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/6711656-query-tab-naming
I am sure I am missing some...lol [image] . I know Red Gate is definitely busy, but it would be great to see something done about tab management.
I know there are some ways to customize the tabs in SSMS as well, but its not nearly as flexible as it should be. I have also used SSMS's Solution Explorer but for some reason Solution Explorer in SSMS is not working like it used to. Even when it did, it would just list the ambiguous script file name which was generic (SQLQuery4.sql, etc) unless you took the time to save the file to a meaningful name. Which was kinda silly to do since they are really temporary in most cases.
Sorry, I kinda went on a rant...I'll get off my soapbox now. [image] / comments
Thanks @way0utwest!
Yes, the projects are broken up into environments and in one environment I might be in one phase and in another environment I might be in another phase. I could keep everything...
@way0utwest , sorry for not being clearer. I did however enter this issue as a support ticket and found out that this issue is actually a bug with SOC and SSMS 17. Apparently when you deselect a database that is linked in SOC it doesn't release it from all the other instances and it just remains locked. Jessica Ramos is escalating it to Development to address the issue.
I would say, even the PID would be a great benefit, it is at least *something* you can attempt to track down and resolve the issue. Right now you are just stuck fumbling around until you find the offending instance. / comments
@way0utwest , sorry for not being clearer. I did however enter this issue as a support ticket and found out that this issue is actually a bug with SOC and SSMS 17. Apparently when you deselect a ...
To get the scriptsfolderxml file you need to go into SQL Source Control for the specific database you are comparing against. Then go to the 'Under the Hood' section and you will see a section labeled 'SQL Compare XML fragment'. That will be the XML you are looking for. It should give you what you need. Good luck! / comments
To get the scriptsfolderxml file you need to go into SQL Source Control for the specific database you are comparing against. Then go to the 'Under the Hood' section and you will see a section labe...
@madnik7 I would think the only way to keep this from occurring is to use the feature that was added in SQL Prompt a few versions back that allows for a special comment to be used to force SQL Prompt to not format certain text. The comment is as follows:
-- SQL Prompt formatting off
<Whatever is between the comments lines won't be formatted
-- SQL Prompt formatting on
Other than that, I think the only solution would involve development. You could definitely post a suggestion on the SQL Prompt UserVoice here: https://redgate.uservoice.com/forums/94413-sql-prompt
I hope that helps.
--Adam Hafner / comments
@madnik7 I would think the only way to keep this from occurring is to use the feature that was added in SQL Prompt a few versions back that allows for a special comment to be used to force SQL Prom...
@BenKentzer , I actually opened a ticket with Red Gate support on this very issue. They found that for some reason SQL Source Control is not releasing itself from the instances when you deselect the database from the Object Explorer. They are aware of this and submitted a bug to development to resolve this, but it effects anyone running SSMS 2017. / comments
@BenKentzer , I actually opened a ticket with Red Gate support on this very issue. They found that for some reason SQL Source Control is not releasing itself from the instances when you deselect t...