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

Gift,

I'm also a woman in IT, but that doesn't mean I believe exercise solves all problems.  Being an ex-athlete, I won't disagree that it helps.  I can't get through a...

Now there's a thought that never occurred to me.  And it should have considering how many chronic & manic depressives I know.  Chronic / Clinical Depression is one thing I...

Ouch.  Now that's a good point.

What part of Katmai isn't working in the other versions of Vista?  Client tools or server?

I can see the server not working in Vista because Vista is a PC OS...

Wow.  All the times I did index creation and I never saw it. 

Huh, the things you learn when you do a "start from scratch" cert studying experience. @=)

The first story was "Just My Luck" in the Transformers: Legends anthology (editor: David Cian) published by iBooks in November 2004.  Unfortunately, the company's founder died and the iBooks itself went out...

If I'm not mistaken, wasn't TestKing accused of being a dump a few years ago?