Comments
Sort by recent activity
Can you try adding the <force/> tag to your XML and see if that fixes your issue? See the bolded text below... <?xml version="1.0" encoding="UTF-8"?> <span><commandline><br></span> <span> <database1>database1</database1><br></span> <span> <username1>username1</username1><br></span> <span> <password1>password1</password1><br></span> <span> <server1>server1</server1><br></span> <span> <database2>database2</database2><br></span> <span> <username2>username2</username2><br></span> <span> <password2>password2</password2><br></span> <span> <server2>server2</server2><br></span> <span> <options>Default</options><br></span> <span> <options>DisableAndReenableDDLTriggers</options><br></span> <span> <options>DisableAndReenableDMLTriggers</options><br></span> <span> <synchronize/><br></span> <span> <include>Table</include><br></span> <span> <include>Table:\[Yadda\]</include><br></span> <span> <include>Table:\[Yadda1\]</include><br></span> <span> <include>Table:\[Yadda2\]</include><br></span> <span> <include>Table:\[Yadda3\]</include><br></span> <ExcludeColumns>Yadda3]$:Status</ExcludeColumns> <b><force/></b><br> </commandline> / comments
Can you try adding the <force/> tag to your XML and see if that fixes your issue? See the bolded text below...<?xml version="1.0" encoding="UTF-8"?><span><commandline><br></span><span> <data...
@mattkollar can you send me what your command line looks with the argfile switch contents? I have done some work like this so I could probably help if you could give me some additional details. / comments
@mattkollar can you send me what your command line looks with the argfile switch contents? I have done some work like this so I could probably help if you could give me some additional details.
In my experience, these either need to be sent to support@red-gate.com as a bug, or you can submit them on the SQL Prompt UserVoice page as feature enhancement requests. / comments
In my experience, these either need to be sent to support@red-gate.com as a bug, or you can submit them on the SQL Prompt UserVoice page as feature enhancement requests.
@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 ...