Ah. Okay.  Sorry about the misinterpretation. 

At least you got it working.

Ah-ha!  That actually makes sense.  And explains why it keeps resetting everytime I look at it.

Thanks, Crispin.  I'm mailing out your cookie now. @=)

What's different in the OS / Server configuration between your QA environment and your Production environment.  This is probably what's causing the issue.

I'm guessing it has to do with...

This is a very interesting topic.  Even more so because this subject crosses career lines and isn't an IT Only problem.  When I was in Customer Service, I had some...

Oddly enough, my first real SQL DBA job was the toughest to get for me too.  No one wanted to hire me because I didn't have enough SQL Server experience,...

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...