Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    4

    Red face Unanswered: How to show all aliases in SQL 7 ?

    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

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Post Re: How to show all aliases in SQL 7 ?

    RE:
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •