Re: SQL 2005, sysobjects and security



Erland Sommarskog wrote:

So when you say that sa can't access sysobjects, I need to ask how you
have arrived at this conclusion

This is elementary Dr.Watson.
If you cannot see it, you cannot access it.

The reporting tool displays nasty message - "Table X has no columns."

I'm at home now, will try you solution tomorrow.

MH
.