Oh, and I did mean to post a reply to one of the first questions on this thread.  As others have said, unless you have the actual MCDBA certification, you...

All,

Sorry it took so long for me to respond.  Just got back from Rhode Island yesterday.  I'm glad you all enjoyed the article.

Several people bring up some good points.  I'll definitely...

Anil,

Unfortunately, this is something that is changeable depending on what types of information you keep track of in your database and what type of business you have.

Part of our SOX...

I can hardly find anything in BOL about either NTLM or Kerberos.  What I can find seems to indicate this is a server setting, not a SQL setting.  Any thoughts...

Steve,

Unfortunately, even that practice wouldn't fly at my work place.  Everything must go through a rigorous SDLC.  We put things into Test, have the BAs test it.  We put it...

I double-checked.  Only one of my servers is using a different domain account than the other 3, and that wasn't the server I was trying to link to.  The other...

Can you imagine what would have happened if that email had been intercepted by a malicious user / hacker? 

YIKES!!!

Actually, all the servers are running under a domain user account and they should be (I'll have to check) running under the same one.  We have to use domain user...

Thanks, Carter.  It's nice to know I'm not the only one with issues regarding this.

I might submit this to MS as a bug in the GUI unless someone can point...

I've added feedback to Microsoft's site.  If anyone would like to vote on the issue it's located at: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=283525

Issue ID 283525 and titled "DDL Triggers do not restrict sp_AddRoleMember".

Thanks...

The situation is that some of the Developers have access to a SQL Server login with DB_Owner permissions (and password) so they can give our application access to a specific database.  And since the...

Thing is, I don't want to just monitor them.  I want to prevent anyone from using them and record the efforts of those who try to add users to roles. ...

Oh, I forgot to mention that I did indeed add log code (as you can see above), but the code didn't log anything even when the trigger did work correctly.

Maybe...

Steve,

Since I posted my problem, I've actually tested the sp_adduser event against my triggers and the triggers do indeed work against that even though I'm a sysAdmin.  They just don't...

Loner,

I'm glad we could help.  From what you've just posted, it seems you're in a lose-lose situation.  Personal life stress has crossed into work stress and work stress has crossed...