Lots of people asked me to write a follow-up blog post where we can deny drop permission for a table from the SQL Server Security Standpoint.
However, sometimes it is fun to learn new things as well. Let us learn how you can check if a column exists in a table from SQL Server 2016 and onwards.
I had a very interesting situation where I had to find all the threads which are not counted for max worker threads in SQL Server. Let us see the script.