I'm trying to programmaticly pull user permissions for tables, views, procs, etc..
I can do this within Management Studio:
EXEC sp_helprotect 'prcProcedureName'
EXEC sp_helprotect 'dbo.prcProcedureName'
However, when I programmaticly do it from VBS or VB6 I get an error saying:
"There are no matching rows on which to report."
Is there another way to do it and why does this only work within Management Studio?