Here is a script that will list the principals and their related permissions, but remember that the user may also have rights to different roles too that have additional permissions.

select...

If you were to provide sample data and the expected outcome it would make it easier on us and less guessing.

Mine is just a little slower than yours. 😉

Since you are on 2012 you should use the TRY...CATCH blocks:

SET NOCOUNT ON;

DECLARE @sql NVARCHAR(101)='SELECT 1/0'

DECLARE @r TABLE (R INT)

DECLARE @T TABLE (Z INT)

BEGIN TRY

BEGIN TRANSACTION

INSERT INTO @r...

Welcome to the forum! First please read the article in my signature and provide the information it talks about (create table statements, insert data statements and expected output).

With that said...

The drive that MSDB is on are there other databases on their too? i.e. Master, model, etc? I know you said you were able to backup those databases and user...

Check out these resources:

Default Trace:https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

EE:https://www.simple-talk.com/sql/database-administration/getting-started-with-extended-events-in-sql-server-2012/

You can't prevent this from writing to the transaction log, but you could preform tlog backups more frequently during this process to keep the size to a minimum.

I would look at this part of your where clauseand (spt.IsNextOfKin=1)or /* using OR as not ALL employees meet the three conditions */

([set].IsNextOfKin=1)or

(sat.IsNextOfKin=1)

If you want one of those three to...

Do you want to prevent them from dropping objects? If so, you could write a DML trigger to prevent that:http://technet.microsoft.com/en-us/library/ms191524(v=sql.105).aspx. Or you could use the trigger to write the action...

GilaMonster (12/10/2013)

Currently at 350 posts a month. If that is sustained,...

Gail first ever SSC - Forever! We should start a pool on when she will reach SSC -Guru.

Also what about the NBA? 38387 = Kareem?

Check out this document:http://technet.microsoft.com/en-us/library/dd638062(v=sql.100).aspx

but this is the quote you are looking for:

SQL Server 2008 updates must be installed under an account that has administrative privileges on the computer where they...

A little late, but congrats Gail! Truly impressive feat.

Sorry for extending the lead of the thread over you :Whistling:

If you have access to the summit recordings Bob Pusateri did a whole session on how to keep track of your sysadmin level accounts: http://www.sqlpass.org/SessionResources/SessionDetails.aspx?sid=4386

The best option is to create...