Month: February 2017
Apply ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to SQL Server
We needed to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to specific databases on a SQL Server 2008 instance, I found to do this even with users off I was being shown errors stating it must be done in Single User Mode. I decided I wanted to do this as quickly as possible so slapped together some SQL…
Add a user to DatabaseMailUserRole on msdb
I had a user unable to use a script which generated an email, I found the user didn’t have permission, Microsoft state: To reduce the surface area of SQL Server, Database Mail stored procedures are disabled by default. To send Database Mail, you must be a member of the DatabaseMailUserRole database role in the msdb…