September 12, 2008 at 3:41 pm
I was just told today that DDL triggers can't override an established Policy Management "thing" on a server. Now I find it a bit hard to believe that MS has covered every possibility on this given my previous experience with DDL triggers, so I'm coming to the group.
I am offering that old standby, the "Marvel No-Prize" for anyone who can help me discover a DDL trigger that gets around the Policy Management capabilities of SQL 2k8.
Anyway want to help me take up the challenge? @=)
September 13, 2008 at 3:26 am
I'll give it a try, however, since the policies are implemented as DDL triggers behind the scenes, I don't think it's possible.
Are you talking about a policy that prohibits a certain change (like forcing all databases on a certain server to be in full recovery)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 16, 2008 at 10:51 am
Well, see, that's what I wasn't sure about. How the global policies in 2008 actually functioned under the hood, that is.
I'm referring to a situation that I ran into with SQL 2k5. There is a DDL trigger which prevents users from being added to roles, but ISTR that when I tried it, there was a system stored procedure which allowed me to circumvent the DDL trigger.
I don't remember exactly what it was (I discovered it sometime last year), but I do recall posting about it here and at MS's website. I think they may have put a note about this issue in the "Fix for 2008" category (completely ignoring the fact that we might want it fixed for 2005 as well).
@sigh. Yet another problem with MS. They'll solve our problems, but only for the next iteration of SQL. We still have to live with the bugs on the current version. @bleargh.
September 16, 2008 at 11:23 am
I'll give it a try, but it won't be in the next couple of days. I've got *real work* that needs doing :crying:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 16, 2008 at 12:04 pm
Me too. Which means I can't fiddle with SQL 2008 nearly as much as I want to.
@sob!
July 16, 2010 at 6:19 am
DDL triggers would have an internal hierarchy wouldn't they? kernel stuff up high, security stuff, server scope, db scope.. or something?
July 16, 2010 at 6:35 am
Please note: 2 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply