Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Nakul Vachhrajani is a Technical Specialist & Systems development professional with iGATE. He holds a MCTS (SQL Server 2008: Implementation & Maintenance)
Browse by Tags · View All
#SQLServer 305
SQL Server 304
Administration 252
DBA 241
T-SQL 234
#TSQL 232
Development 226
Tips 216
Guidance 148
Best Practices 119

Archive · View All
April 2011 14
March 2012 11
December 2011 11
March 2011 11
December 2012 10
October 2011 10
January 2011 10
September 2013 9
January 2013 9
November 2012 9

#0221 - SQL Server - SSMS - Database Properties - Number of Users value

Dec 13 2012 12:00AM by Nakul Vachhrajani   

Recently we were working on adjusting the configuration on a database which had just been moved to another server during a routine technology upgrade of our development servers (Reviewing and configuring your SQL Server instance). No users were yet allowed in the system and hence, one of the team members was surprised to note a “Number of Users” count higher than 1 in the database properties window of the SQL Server Management Studio (Getting Started with SSMS).


The team member obviously thought that the value of “Number of Users” indicated the number of distinct, currently open connections to the database. The confusion that the team member went through is understandable, and that’s what inspired me to write this quick post today.

The “Number of Users” value is actually the number of database users associated with the database – it is not, I repeat: not, the number of concurrent users connected to the database at a given point in time.

The number of users associated with a database for AdventureWorks2008R2 sample database is 4:


I trust the above quick post helps clear out the confusion around the “Number of Users” value in the database properties window of SSMS.

Until we meet next time,

Be courteous. Drive responsibly.

Tags: #SQLServer, SQL Server, Administration, DBA, Tools and Utilities, SSMS

Nakul Vachhrajani
4 · 36% · 11648



  • Thanks Nakul!

    commented on Dec 13 2012 12:33PM
    200 · 1% · 238
  • Glad you liked it, athea!

    commented on Dec 14 2012 12:42AM
    Nakul Vachhrajani
    4 · 36% · 11648
  • Thank you Nakul!

    I have one doubt. We are using SQL Server 2012. I have db_owner permissions on my project database. When i am trying to see database properties it is giving me the error. User does not have permissions to perform the action.

    Why its giving me the error. Can you please help me on this.

    Regards, Ramkoti

    commented on Dec 17 2012 12:20AM
    391 · 0% · 105
  • Thanks Sir

    commented on Dec 17 2012 1:12AM
    Ashish Jain
    453 · 0% · 88

Your Comment

Sign Up or Login to post a comment.

"#0221 - SQL Server - SSMS - Database Properties - Number of Users value" rated 5 out of 5 by 10 readers
#0221 - SQL Server - SSMS - Database Properties - Number of Users value , 5.0 out of 5 based on 10 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]