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 301
SQL Server 300
Administration 251
DBA 240
T-SQL 231
#TSQL 229
Development 224
Tips 213
Guidance 146
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).

0221A

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:

0221B

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% · 11533
10
 
0
Lifesaver
 
 
 
0
Incorrect



Submit

4  Comments  

  • Thanks Nakul!

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

    commented on Dec 14 2012 12:42AM
    Nakul Vachhrajani
    4 · 36% · 11533
  • 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
    Ramkoti
    387 · 0% · 105
  • Thanks Sir

    commented on Dec 17 2012 1:12AM
    Ashish Jain
    448 · 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]