First of all, Merry Christmas and Happy Holidays to everybody. I wish you all the best in the holiday season.
In today’s blog post – I am sharing a very small question received by one of the readers. Though simple, sometimes a small question makes people think. He sent me an image very similar to the following one and asked a few questions. As his image represented his server’s information, I am reproducing a very similar image using AdventureWorks
database.
Question: What does the number of users signify in database properties? Does this mean current connected users or total active users or total enabled users or what exactly?”
Answer: Database Properties >> Number of Users indicates how many users exist in the database.
In my current example, you can see that there are 5 users and that is displayed in the above properties screen. Though it is very simple question, now I am going to ask you a question back.
Question to readers: If you notice, there is a small arrow besides GUEST or SYS login. It is a RED arrow on the south. What does this arrow mean?
Please leave your answer in the comments area.
Reference
Pinal Dave (http://blog.SQLAuthority.com)
Filed under: CodeProject, Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2200 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of two SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.