Activity overview
Latest activity by Jacco
I have SSMS 17 and 18 installed side-by-side, as well as Visual Studio 2017 and 2019. SQLPrompt worked in SSMS 17 and VS 2017, but not in SSMS 18 and VS 2019. I uninstalled and re-installed SQLPrompt and it now works in SSMS 2017 and 2019, as well as VS 2017, but it still doesn't work in VS 2019. / comments
I have SSMS 17 and 18 installed side-by-side, as well as Visual Studio 2017 and 2019. SQLPrompt worked in SSMS 17 and VS 2017, but not in SSMS 18 and VS 2019.I uninstalled and re-installed SQLPromp...
BUG: Rule IE028 raises warning when adding a PERSISTED computed column
There is an IE028 warning ("Adding NOT NULL column without DEFAULT value") on the third statement, but not on the other two. CREATE TABLE dbo.Test_EI028 (t1 AS (1) PERSISTED NOT NULL);
ALTER TABLE...
Hi @Michael Clark,
It works now.
Thanks,
Jacco / comments
Hi @Michael Clark,
It works now.
Thanks,
Jacco
The update doesn't show for me. I'm on 9.0.6.3580 and I get the message "No updates available" when I check for updates. (SSMS 17.4 and VS 15.5.4) / comments
The update doesn't show for me. I'm on 9.0.6.3580 and I get the message "No updates available" when I check for updates. (SSMS 17.4 and VS 15.5.4)
DBCC CLONEDATABASE not showing in Intellisense on SQL 2014 SP2-CU8
SSMS 17.4 SQLPrompt 9.0.4.3408
It should be available in Intellisense, but it isn't. It is available when I connect to a server that runs SQL 2016 SP1-CU6.
Code Analysis/Code Guard: "The value assigned here is never used"
I've installed SQLPrompt 9, and SQL Code Guard, the latter to be able to run a summary across a database, as SQLPrompt doesn't have that ability yet. I use SSMS 16 when using Code Guard, and SSMS 1...
Thanks Fabiola, I'll post a request on UserVoice. / comments
Thanks Fabiola, I'll post a request on UserVoice.
Thanks for the answer Alessandro.
It would definitely be useful to be able to set a path for the file. I see that there is already a suggestion in this direction on UserVoice, so I'll add my vote and comment to that. / comments
Thanks for the answer Alessandro.
It would definitely be useful to be able to set a path for the file. I see that there is already a suggestion in this direction on UserVoice, so I'll add my vote a...
How do I share my list of enabled Code Analysis rules?
I've analyzed the rules in Code Analysis and disabled a bit less than half of them. How can I share this list with my development team so they can easily import it instead of manually having to dis...