Great script! Thanks

Thanks for hanging in. The following groups have full control. There is nobody else and "deny" permissions haven't been implemented:

-Administrators (local\Administrators)

-System

-Creator Owner

Yes. I'm sorry that I wasn't clear. It was working until recently. There are no evenvwr entries that seem to jump out at me.

I appreciate it. The same group mentioned earlier is in the local administrators group.

Both another person in the same group and the 'sa' account have the same problem.

I'm in a group that is mapped to all server roles.

Good idea and a neat approach.

Thanks for sharing your work.

Good Article! Thanks.

It is interesting what you said about SQL2000.

Well I couldn't get the previous recomendation to work. And unfortunately my target table requires special formating for its identity...

Hmmmm... It was with the first script "Create Schema Authorization" but the entire exercise worked fine this morning. The fn_getDuration function is nice little headbanger.

Thanks for your...

Thanks for your work. I must have screwed something up but when I ran the 'Create Schema' script I received the following error:

Server: Msg 156, Level 15, State 1,...

Good article. In my environment, security is constantly under review. IIS + SQL (same server) = BAD. Enjoyed seeing the other reasons.