“Why can’t I login after the database restore?” As a DBA, this is one of the questions I get most.
Sometimes it is nessesary to deny updates on a table, but allow inserts. This is the case when the history must never be changed, for instance in a table with accounting data. This can be done in two different ways. … Read more →
SQL Server roles can be used to give users server wide privileges. The server roles are sysadmin, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator and bulkadmin. The mapping between users and server roles can be found in the system view sys.server_role_members. … Read more →
The system table sys.syslogins was marked as deprecated in SQL Server 2005, and is included up until 2012 for backwards compability only. So what is the replacement of sys.syslogins? As it turns out, there is no exact match in SQL … Read more →
If you are using SQL Server log shipping (or mirroring), you probably want to copy the logins from the primary server to the secondary. When databases are log shipped, the users go along with their respective databases. But those users … Read more →