To restrict one session per user

Comments

• Options

  mohana_cse06 Member Posts: 5,503

  2011-11-11

  hope it helps you
  http://mibuso.com/blogs/mohana/2011/07/20/login-stored-procedure-on-the-sql-server-option/

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0
• Options

  digvansh Member Posts: 6

  2011-11-11

  mohana_cse06 wrote:

  hope it helps you
  http://mibuso.com/blogs/mohana/2011/07/20/login-stored-procedure-on-the-sql-server-option/

  thanks for the link...will check and update...

  0
• Options

  bbrown Member Posts: 3,268

  2011-11-11

  Are you sure the performance issue is a factor of the number of sessions?

  There are no bugs - only undocumented features.

  0
• Options

  David_Singleton Member Posts: 5,479

  2011-11-11

  bbrown wrote:

  Are you sure the performance issue is a factor of the number of sessions?

  
  I think he means "Bank Account Performance"

  David Singleton
  

  0
• Options

  digvansh Member Posts: 6

  2011-11-11

  David Singleton wrote:

  bbrown wrote:

  Are you sure the performance issue is a factor of the number of sessions?

  
  I think he means "Bank Account Performance"

  not sure...server configuration is HP Intel xeon 2.4 GHz, 8 GB RAM Windows Server 2003 R2 SP2, 35 RDC users, SQL 2005 Enterprise....should we add another processor for performance..

  0