Error 4064 Return When User Connects via SSMS

Views – 990

SQL Server Audit: Resources

I am doing some research on how to implement auditing of schema and security changes and will use this post to track notes…

Log-shipping Logins Roles and Rights

Per the MSDN article below, accounts used to perform log-shipping tasks must be a member of the ‘sysadmin’ server role group: “The log-shipping…

Enabling and Disabling SQL Logins

Here is some simple T-SQL to enable or disable a SQL login account:

Views – 842

SQL Server Roles

SQL Server-level Roles • SysAdmin: Allows users to perform any activity on the server. • ServerAdmin: Permits users to manage configuration options on…