Comments
Sort by recent activity
First, which version are you using. Prompt revs so often that "latest" is hard to know.
I don't know we can do this exactly. If you edit formatting styles, there is an INSERT item on the left. [image]
Under here, I think the last item in the first row matches closely to what you want with the always option selected. We don't have a good option to only put the first item on the end of the line. That seems like an option that inconsistently lists items to me, but that may be what you want. I'd suggest you add this to Uservoice if it's important to you. [image]
Below that, the VALUES item list, second item in second row, might be what helps you with the Values clause. [image] / comments
First, which version are you using. Prompt revs so often that "latest" is hard to know.
I don't know we can do this exactly. If you edit formatting styles, there is an INSERT item on the left.
Unde...
It's not possible to customize the tree right now. We put all the objects in the folder as a flat format, which is the same format used by Compare, DLM, etc. I'm not sure this is something we'd want to support as how would you designate the procedures in SSMS as being in a folder? We link from SSMS to a similar structure in the VCS. / comments
It's not possible to customize the tree right now. We put all the objects in the folder as a flat format, which is the same format used by Compare, DLM, etc. I'm not sure this is something we'd wan...
You are in the right spot. Click "add Command" and choose the SQL Prompt menu on the left. Then find "Format SQL" on the right. Click it and add it.
Better description: https://voiceofthedba.com/2017/11/14/adding-a-format-sql-button-to-the-redgate-toolbar/ / comments
You are in the right spot. Click "add Command" and choose the SQL Prompt menu on the left. Then find "Format SQL" on the right. Click it and add it.
Better description: https://voiceofthedba.com/20...
Likely here the build agent can't see the license. When you say the same user that runs the build, do you mean that you're using the account the agent is set up under? Is the agent on the same machine you're testing under? In other words, what's the architecture of the build? Where does the agent run with which account?
I can do this, but I think I typically have the agent running under my account, with user/pwd for SQL connections. I thought that Compare would install for all users on a computer, but it's possible that it doesn't and it's linked to a single user. / comments
Likely here the build agent can't see the license. When you say the same user that runs the build, do you mean that you're using the account the agent is set up under? Is the agent on the same mach...
This forum is for questions related to SQL Prompt from Redgate. If you have issues with the SQL Migration Assistant, you might try posting them here: https://www.sqlservercentral.com/Forums/SQL-Server-2016/SQL-Server-2016--Development-and-T-SQL / comments
This forum is for questions related to SQL Prompt from Redgate. If you have issues with the SQL Migration Assistant, you might try posting them here: https://www.sqlservercentral.com/Forums/SQL-Ser...
Reproduced this. I created a proc that uses a linked server, then deleted the linked server. Find Invalid Objects in Prompt doesn't detect this. Reported to the team. / comments
Reproduced this. I created a proc that uses a linked server, then deleted the linked server. Find Invalid Objects in Prompt doesn't detect this. Reported to the team.
Confirmed in 8.2.2.2257. Semi colon should be after ALL, or on the line above GO. / comments
Confirmed in 8.2.2.2257. Semi colon should be after ALL, or on the line above GO.
The entire SSMS2014 window closes? Are you linking to an empty folder in your git repo?
Also, which git version? / comments
The entire SSMS2014 window closes? Are you linking to an empty folder in your git repo?
Also, which git version?
You can, but if you perform other In-Memory OLTP DDL, you'll get the error again. This is a bit of an effect of the way DLM Dashboard uses DDL triggers. / comments
You can, but if you perform other In-Memory OLTP DDL, you'll get the error again. This is a bit of an effect of the way DLM Dashboard uses DDL triggers.
I've got the file (BTW, upload as ZIP should work). The options are dramatically different as I look through them. I don't know that I can get a mapping from options such as 1 to Upper Case for the enums in the old styles today, but I've left a few messages with development to try and sort this out. When I look through your style, I can't quite tell what items to map across.
I'll update as soon as I can. / comments
I've got the file (BTW, upload as ZIP should work). The options are dramatically different as I look through them. I don't know that I can get a mapping from options such as 1 to Upper Case for the...