• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 155
  • Last Modified:

SQL newbie question

Hi.

Is it possible to capture actions that are made on tables in SQL Server 2000, using VB events?
In other words, does SQL Server 2000 (using its reference objects) raise events such as TableUpdated etc. ?
0
ophirg
Asked:
ophirg
1 Solution
 
SethiCommented:
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.
0
 
Éric MoreauSenior .Net ConsultantCommented:
The only thing I am aware of is the Notification Services. See http://www.microsoft.com/sql/NS/overview.asp
0
 
jayeshshahCommented:
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
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
CleanupPingCommented:
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?
0
 
DanRollinsCommented:
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
0
 
YensidModCommented:
Question is PAQ'd and no points refunded.

YensidMod
Community Support Moderator @Experts Exchange
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now