sayfrend (3/27/2008)
Executed : exec sp_helprotect 'dbo.profiler'Result : "Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291
There are no matching rows on which to report."
Conclusion : What is this ?
Note : I could exec sp_helprotect, with out any errors.
For the record, you get that error if there are no permissions defined for the object. I also noticed if the object has no permissions defined but the schema does, you still get the above error.
I've actually found Red Gate's SQL Source Control to be a better option for viewing object permissions, since it gives you the GRANT statements you would execute.
Tony
------------------------------------
Are you suggesting coconuts migrate?