Activity overview
Latest activity by SloopJohnB
Thank you @Tianjiao_Li. I just added this to the User Voice Forum. / comments
Thank you @Tianjiao_Li. I just added this to the User Voice Forum.
Insert Semicolon Issue with CTEs
SQL Prompt's "Insert semicolon" function behaves weirdly when a CTE is a the start of a control loop. For example, if I have this code:IF (1=1) BEGIN WITH numbers AS ( SELECT 1 AS num UNION...
Thank you! That is very helpful to know. My project is source controlled, so I need to make sure that the relevant items in the Schema-Model folder are manually checked out before attempting migrations. I may end up just continuing to use Visual Studio for this, but I would like to try to use SSMS because it seems more natural for me to do my work there instead. / comments
Thank you! That is very helpful to know. My project is source controlled, so I need to make sure that the relevant items in the Schema-Model folder are manually checked out before attempting mig...
Schema-Model Folder in SSMS Add-in
I'm trying out the SSMS add-in with a a SCA project which I set up in VS 2017. When I review the available files under "Migrations", I do not see the Schema-Model folder:Is the folder created but...
Thank you! / comments
Thank you!
Is Post-Deployment File Grouping Possible?
My Post-Deployment folder is starting to get very large. I would like to put the scripts into subfolders to make it easier to find particular scripts. Can SQL Change Management Automation work wi...
Edit Multiple Items?
Hello -
I'm working with v3 extensively for the first time today. In v2, you were able to make edits to multiple fields via a popup dialog box. This allowed for the save operation to be issued ju...
Hi -
I ran into the same issue raised by the OP, and tried setting up an RGTEMP environment variable pointing to a drive with more space. But the setting doesn't seem to work. Does it matter if environment variable is a system variable or a user one? / comments
Hi -
I ran into the same issue raised by the OP, and tried setting up an RGTEMP environment variable pointing to a drive with more space. But the setting doesn't seem to work. Does it matter if e...
I know you can open up multiple tabs (and do). But I tend to open a session for each distinct tasks/projects I might be working on at the same time. Having one instance for each is easier to deal with than trying to sort through 20 different tabs trying to figure out what goes with which. / comments
I know you can open up multiple tabs (and do). But I tend to open a session for each distinct tasks/projects I might be working on at the same time. Having one instance for each is easier to deal...
Support for Multiple SSMS Instances
Is support for multiple SSMS instances something that is planned? I usually have SSMS windows abound on my PC, but alas SQL Source Control only likes one...