Posts
Sort by recent activity
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...
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...
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...