Home Forums SQL Server 7,2000 Administration How to find Users of a particular table RE: How to find Users of a particular table
spaghettidba
SSC Guru
Points: 105732
More actions
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