Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

select * from master..sysprotects

6 views
Skip to first unread message

Bkiddo

unread,
Nov 4, 2009, 1:58:50 PM11/4/09
to
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,

Bret_Halford

unread,
Nov 4, 2009, 6:24:51 PM11/4/09
to


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.

0 new messages