Click here to Skip to main content
15,867,488 members
Articles / Database Development / SQL Server

SQL SERVER – Database Properties – Number of Users

Rate me:
Please Sign up or sign in to vote.
5.00/5 (1 vote)
26 Dec 2011CPOL1 min read 29.5K   1   2
SQL SERVER – Database Properties – Number of Users

Image 1

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.

Image 2

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.

Image 3

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?

Image 4

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 Image 5 Image 6 Image 7 Image 8 Image 9 Image 10 Image 11 Image 12

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Founder http://blog.SQLAuthority.com
India India
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.

Comments and Discussions

 
AnswerDownward arrow Pin
inferno986return22-Jul-20 8:10
inferno986return22-Jul-20 8:10 
Questionsignificance of red arrow Pin
Ganeshkumar_Haral20-Jun-12 0:24
Ganeshkumar_Haral20-Jun-12 0:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.