Stuart McLachlan
stuart at lexacorp.com.pg
Thu Aug 7 20:26:44 CDT 2003
On 7 Aug 2003 at 21:03, John Colby wrote: > I use SQL Server 2k for the data store for my billing program. I open the > FE, open a table directly. I then open EM and look at the objects you > mention. I see a lock and a process ID however I don't see any information > about the table being examined. The lock type is DB, mode S, Status Grant, > Owner Sess. That's all I see. > > Am I missing something? If not then SQL Server isn't overly helpful at > identifying who is in the db either. > Look at Process Info - it includes Username and Application Name and the time thast SQL command was run. Right click on Double click on a process and it shows the last SQL executed which will tell you what tables were acccessed. -- Stuart McLachlan Lexacorp Ltd Application Development, IT Consultancy http://www.lexacorp.com.pg