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

  • This is easy,

    Down Red Arrow means disabled, like every one mentioned in their replies.

    Starting SQL Server 2005, Microsoft disabled Guest account in msdb and model database for security reasons and all sample databases.

    This account will still be enabled in master and tempdb database.

    For Security reasons, it is advised that guest account is disabled in user databases and public role should not be given access to any object in any database.

    ~ IM.

    Reply
  • hi..
    Red arrow signifies login is disabled..

    Reply
  • Login is disabled..

    Reply
  • “The Hidden Tiger”:

    Hi pinal,

    I found hidden tiger , which is exactly above the visible tiger inside the image..

    Reply
  • The one tiger standing and looking at front actually looking the other tiger and only the shadow of other tiger is there.

    Reply
  • User guest is denied to connect to the database adventureworks.

    use adventureworks;
    grant connect to guest;

    This will resolve the problem.

    Reply
  • Good one Pinal.
    I started to worry when saw only 5 at the first time.
    Thanks

    Reply
  • Thanks Pinal, Question: When you buy SQL License do you look at this value? if not then what should we look to buy SQL License appropriately?

    Reply

Leave a Reply