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
