[AccessD] Who is linked to my back end?

All it says is SP_Execute;1

According to help I should see the SQL statement, but I don't.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Thursday, August 07, 2003 9:27 PM
To: John Colby; accessd at databaseadvisors.com
Subject: RE: [AccessD] Who is linked to my back end?


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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com