 |  |  |  |  |  |  |  |
access reporting on MSSQL-DB
Please support our MS SQL advertiser: Intel Parallel Studio Home
 |
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).
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).
|
Similar Threads
- Server Report "Page Cannot Be Displayed" (Windows NT / 2000 / XP)
- Browser Hijack- Random infrequent browser redirection &/or popups. (Viruses, Spyware and other Nasties)
- IE Opens by itself (hijack log included) (Viruses, Spyware and other Nasties)
- Help me.. Rundll 32 is not responding..Cann't shutdown window (Viruses, Spyware and other Nasties)
- Task Manager won't stay open (Viruses, Spyware and other Nasties)
- Help ! Cann't shut down window (Viruses, Spyware and other Nasties)
- can't get taskmanager to stay open (Viruses, Spyware and other Nasties)
Other Threads in the MS SQL Forum
- Previous Thread: Help Needed with Sub Query
- Next Thread: Transfer values betqween two asp pages
| Thread Tools | Search this Thread |
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS SQL
"last autogrowth business connectingtodatabaseinuse count cursor data database dateadd datepart day" dbsize deadlock delete_trigger exploit getdate hack highperformancecomputing hpc hpcserver2008 ibm iis limit loop maximum microsoft ms mssql multiple multithreading news number password permission position query reporting result security server services sets single source sql sql-injection sqlserver sqlserver2005 subtype supercomputing supertype tables uniqueid update view weekday
