How do I grant permissions to view users and their permissions?
tl;dr; VIEW DEFINITION
Every now and again you’ll have a user that needs to be able to see what permissions other...
2018-09-17
285 reads
tl;dr; VIEW DEFINITION
Every now and again you’ll have a user that needs to be able to see what permissions other...
2018-09-17
285 reads
tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two...
2018-09-13 (first published: 2018-09-05)
3,405 reads
Anything that happens in a trigger happens within the same transaction of the command that called it.
Part of me feels...
2018-09-11
198 reads
Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database...
2018-09-06 (first published: 2018-08-22)
1,646 reads
In the very first SQL Homework post you were asked to take a backup. In fact it asked you to...
2018-09-03
794 reads
A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar...
2018-08-29
508 reads
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z...
2018-08-29 (first published: 2018-08-16)
3,191 reads
I was reading a post today by Bert Wagner (b/t).
Displaying Long Variable Values in SQL Server
By the way, if...
2018-08-27
822 reads
Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours...
2018-08-20
214 reads
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started...
2018-08-14
372 reads
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Comments posted to this topic are about the item Enable a Disabled Index
Comments posted to this topic are about the item Diving Deeper into the Import...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers