A SQL Server Login Script Like No Other . You can copy SQL Server logins from one box to another the hard way, or take the easy route by getting an assist from the SP_HELP_REVLOGIN proc. By Eric ...

In SQL Server 2005 SP 2, Microsoft introduced logon triggers into the core functionality from the SQL Server. DDL and DML triggers , these triggers fire on particular events, in this case, whenever a ...

Log Shipping and Logins. Establishing a failover server for your SQL Server? First things, first: strategize on your logins. By Eric Johnson; 06/28/2010; So you decided to set up log shipping in ...

Selects the authentication mode from one of the following: SQL Server with login ID and password. Windows Integrated authentication using the currently logged-in user's account. Active Directory ...

Navigate the Security page and in the Server, authentication picks the option SQL Server and Window Authentication mode. Then expand Security >>Logins and make a right-click on the server name, and ...

Useful Scripts for SQL Server. Contribute to amitsukralia/DatabaseScripts development by creating an account on GitHub.

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

We can use a logon trigger to audit when members of one of the SQL Server administrative role, such as example the “syadmin” server role, logs on. In this example for audit administrative logins on ...