Scenario
How to find all the users present in a database.
Solution
We can use below TSQL command
|
1 2 3 4 5 |
use ourtechideas --Change the database name for your database go select name from sys.sysusers where issqlrole=0 and name not in ('dbo','guest','INFORMATION_SCHEMA','sys') |
Result
