To restrict one session per user

digvansh

Friends,

mohana_cse06

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

digvansh

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...

bbrown

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

David_Singleton

bbrown wrote:

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

I think he means "Bank Account Performance"

digvansh

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..