SQL newbie question

There are Triggers in SQL Server that are fired whenever some action is being performed in the SQL Server table.

However, there is no direct way in SQL Server, where in a user makes some changes to the table and SQL Server through some objects notifies VB for the same. But there is one possibility. Create a DLL in VB and write code in an event in that DLL. When a user makes some changes in a table fire the event of that DLL. The code in the event will contain some data that tells your application in VB that a change has been made.

Its just an idea to achieve what you want. How to achieve is where you will have to work at.

The only thing I am aware of is the Notification Services. See http://www.microsoft.com/sql/NS/overview.asp

what you can do is checkout the logs in the SQL server but then you would have to distinguish between a log of action performed by the server and a log of action performed by the User.

K'Regards

Jayesh

ophirg:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?

ophirg, an EE Moderator will handle this for you.
Moderator, since no Experts responded, my recommended disposition is:

    Save as PAQ -- No Refund.

DanRollins -- EE database cleanup volunteer