Alias

Is there a way to find out which user(s) are aliased to which databases ?
Thanks.Hi,
Use SP_HELPLOGINS and SP_HELPUSER system stored procedures.
Thanks
Hari
SQL Server MVP
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:895EF8F4-48ED-4F17-912F-0291B6200622@.microsoft.com...
> Is there a way to find out which user(s) are aliased to which databases ?
> Thanks.|||If you *really* mean aliased (the feature not supported by GUI since 6.5), added by sp_addalias,
then use sp_helplogins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:895EF8F4-48ED-4F17-912F-0291B6200622@.microsoft.com...
> Is there a way to find out which user(s) are aliased to which databases ?
> Thanks.