Wednesday 29 April 2015

How to find how many user are mapped with particular login in SQL Server?

Sometime we need to check how may user has been associate with particular login .So ,here is cool system SP's through we can check this .


EXEC MASTER..sp_MSloginmappings [ashish-pc\ashish]


Out Put :-











EXEC sp_helplogins 'ashish-PC\ashish'

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)