Member Avatar for ries.vos
ries.vos 0 Newbie Poster

I have an external application running on a MS SQL server2005 (express-edition) database.

I need a notification each time the application reads a special table from the database.
As a new user of MsSQL I experienced with the trigger function. But this is only applicable when fields in a table are Updated or Deleted. I need reporting if a table is only read.
Maybe I have to define logfiles for getting the access information.

Can anybody give suggestions how to get reporting when an external application accesses a table in the DB (reading only).

  • 1 Contributor
  • 0 Replies
  • 55 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.