Is different the information you get if you run:

select * from master..sysprotects

than the one you obtain from:

select * from sysprotects ?


I need to ask because I don't have data base to test them, thanks,

On Nov 4, 11:58*am, Bkiddo <beatriz.du... (AT) gmail (DOT) com> wrote:

These would be the same if the user was currently in the master
database,
otherwise different. "select * from sysprotects" will get the results
from
the sysprotects table in the database the user is using.