Comments
Sort by recent activity
I get that the alias isn't appearing first, which seems like a problem. however, the columns with the alias appears just below the item you've boxed in. If you arrow down3 times, you'll have t1.col1. I think this is a sorting issue with the product. I'll report this. / comments
I get that the alias isn't appearing first, which seems like a problem. however, the columns with the alias appears just below the item you've boxed in. If you arrow down3 times, you'll have t1.col...
Which version of SQL Source Control and Git? I haven't seen this. Is this an empty repo or one that you've pulled down source from a remote that is in SQL Source Control format? / comments
Which version of SQL Source Control and Git? I haven't seen this. Is this an empty repo or one that you've pulled down source from a remote that is in SQL Source Control format?
You are welcome. Glad to help. / comments
You are welcome. Glad to help.
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.