First of all Merry Christmas and Happy Holidays to everybody. I wish you best holiday season.
In today’s blog post – I am sharing very small question received by one of the reader. Though simple sometime a small question make people think. He sent me very similar to following image and asked few questions. As his image represented his server’s information, I am reproducing very similar image using AdventureWorks database.
Question: What does the number of users signifies 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 the how many users exists 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 question back.
Question to readers: If you notice there is small arrow besides GUEST or SYS login. It is RED arrow on south. What does this arrow means?
Please leave your answer in comments area.
Reference: Pinal Dave (http://blog.SQLAuthority.com)