Anybody have any ideas?

Thanks

We use SQL Diagnostics Manager to monitor our 2000/2005/2008 servers. After using it 2 or 3 years, we are still very pleased.

Thanks Hugo. I have forgotten how to read.

When I do a 'select * from sys.tables' on a database with views, only the tables are returned, not the views. This is on SQL 2005. What am I doing...

Oops. I figured it out.

Excellent article.

I have one question about the workaround. If a person has SecurityAdmin, could they give themselves permission to alter the LimitSecurityAdmin trigger?

Chris

Error Codes can be found at http://msdn.microsoft.com/en-us/library/ms681381(v=VS.85).aspx

deleted

I like the Will Rogers qoute in your signature line, Tom. It is appropriate to the discussion.

"There are three kinds of men. The one that learns by reading. The few...

As already noted, the model database can be set to read-only. Before posting a question, how about actually trying it out?