Post reply

aspnetdb.mdf questions (for asp.net wizards)

  • June 12, 2011 at 5:13 pm

    #241272

    I am using aspnetdb within my MSSQL 2008 R2 web database.

    Questions:

    1) How does one get a count of the number of currently on line?

    2) How does one get a list of those userNames who are on line?

    Thanks:-)

  • June 12, 2011 at 9:03 pm

    #1337549

    Digs (6/12/2011)

    I am using aspnetdb within my MSSQL 2008 R2 web database.

    Questions:

    1) How does one get a count of the number of currently on line?

    2) How does one get a list of those userNames who are on line?

    Are you referring to Logins or Users?

    Does your Web Application store the User Connection information in a table?

    You may want to closely examine your Web Database and the ASP.NET Code that is used to access the application.

    As far as SQL Sever is Concerned you may want to acclimate yourself with the following system views:

    SELECT *

    FROM sys.dm_exec_sessions

    SELECT *

    FROM sys.dm_exec_connections

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • June 12, 2011 at 9:09 pm

    #1337550

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply