Does anybody know a command that shows ALL aliases on the database?
Or could I search for them in the system table and make a SELECT for them?
pls. helpRE: Q1 Does anybody know a command that shows ALL aliases on the database?
Or could I search for them in the system table and make a SELECT for them?
pls. help
A1 To get the alias [member] or user status for each login on a Sql Server run:
exec sp_helplogins
If run without specifing a login, the information will appear in the last column (UserOrAlias) of the second result set that the sp_helplogins stored proc returns.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment