How to Login to SQL Server with NT AUTHORITYSYSTEM using PSExec Tool

PSExec tool gives you an option to run a remote process or an application using System account, if SYSTEM account has permission on that application. Although there are many more features that are  For example, if SQL Server has NT AUTHORITY\SYSTEM as one of its logins, then you can use this account to login to…

3

How to limit connections to SQL Server until all databases are ONLINE!

Strange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer was to make sure no application should be able to connect to SQL Server unless and until all the databases are ONLINE. The business requirement of this company was to have all databases online before any of their ten…

8