Considering this "feature" for everything that is SQL Server related, does this mean that all Extended Events related messages are accessible in sys.messages?
Related Posts:
Implicit Conversion Fail May 31, 2019...
2017-12-27
8 reads
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
187 reads
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
938 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-12-27
745 reads
I was doing some research on impersonation the other day, and among other things, I ran across a forum question...
2017-12-27
800 reads
One of my favourite conferences (and so far I was incredibly lucky to have spoken at every edition) is SQLKonferenz,...
2017-12-27
361 reads
A couple of weeks ago, the SQL Server community had their last T-SQL Tuesday of the year – 97th since 2009...
2017-12-26
762 reads
In the spirit of the 12 Days of Christmas and Giving, I have a 12 Day series that I generally try to do each Holiday Season. The series will...
2017-12-26
8 reads
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
185 reads
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
453 reads
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers