Post reply

How to find Users of a particular table

  • September 17, 2014 at 8:23 am

    #104244

    Hi

    Does anyone have or know of any code that I can use to find the users of a particular table in SQL Server 7.0?

    Thanks so much

    Kathy

  • September 18, 2014 at 2:18 am

    #1746307

    What do you mean? The users that have access to it? The users that created it?

    -- Gianluca Sartori

  • September 18, 2014 at 7:35 am

    #1746393

    The users that are actually using the table. So I guess I mean the user that are actively using the table. I did use sp_who2 and found the user, host and database and that helped define the solution to the issue we had.

    But if you know and t-sql commands to find active users against a particular table, please share.

    Thanks

    Kathy

  • September 18, 2014 at 9:03 am

    #1746439

    In SQL Server 2000 your only option is a trace.

    Not easy: you would have to set up a trace that captures all T-SQL activity on that table (filter on TextData LIKE %YourTable%) and then process it aftwerwards.

    -- Gianluca Sartori

  • September 18, 2014 at 3:24 pm

    #1746550

    Thanks for the input--I'll be glad when we are off 6.5 and 7

Viewing 5 posts - 1 through 4 (of 4 total)

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