Comments
Sort by recent activity
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...
OK, I found a converter tool. Please try this style and let me know if it works. / comments
OK, I found a converter tool. Please try this style and let me know if it works.
Can you upload the file for someone to examine? / comments
Can you upload the file for someone to examine?