Granting View Definition to All Procedures

The other day I came across something where I needed to grant view definition rights to a specific user for one single DB. Now, there are several different ways to achieve this but I decided to dabble in just writing some code to take care of it for me. Others might have something very similar …

Continue reading Granting View Definition to All Procedures

Someone Forget to Logoff that Remote Desktop Session?

  Phone rings..... alerts start going off......... coffee hasn't been made yet..... it's 2:13 a.m. and the issue requires you to remote login to the server to perform some task; only to find out that the server has already exceeded the maximum number of users. Has that happened to you before? Has me; either other …

Continue reading Someone Forget to Logoff that Remote Desktop Session?