SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users

SQL SERVER - Merry Christmas and Happy Holidays - Database Properties - Number of Users Merry-Christmas

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.

SQL SERVER - Merry Christmas and Happy Holidays - Database Properties - Number of Users dbnumberofusers

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.

SQL SERVER - Merry Christmas and Happy Holidays - Database Properties - Number of Users 5dbuser

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?

SQL SERVER - Merry Christmas and Happy Holidays - Database Properties - Number of Users arrowinlogin

Please leave your answer in comments area.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column
Next Post
SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped

Related Posts

No results found.

29 Comments. Leave new

Leave a Reply

Menu