Post reply

To know the users are using which tables on a server

  • August 6, 2008 at 4:52 am

    #77062

    I want to know what tables the users are using.

    With sp_who2 we can check all the connections and their actions.but i want to know the users which are using tables only at a present time..

    Is there any way to know this.

    Thanks in advance.

  • August 6, 2008 at 7:33 am

    #853807

    This isn't exactly what you are wanting but maybe it will point you in the right direction. I don't have time to play with it right this minute.

    http://www.sqlservercentral.com/articles/Monitoring/20010422115752/84/[/url]

    MCITP, Database Administrator
    A hodgepodge of Information Technology and Life
    LinkedIn Profile
    My Twitter

  • August 6, 2008 at 10:32 am

    #853984

    Given that users 'use' tables by running DDL or DML statements, you could use sp_who2 to identify users actively running queries, use fn_get_sql or DBCC INPUTBUFFER to get the query text, and identify the tables used from there.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

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

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