?
Solved

SQL newbie question

Posted on 2003-02-23
6
Medium Priority
?
148 Views
Last Modified: 2010-05-01
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
Comment
Question by:ophirg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 18

Expert Comment

by:Sethi
ID: 8002797
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8003048
The only thing I am aware of is the Notification Services. See http://www.microsoft.com/sql/NS/overview.asp
0
 
LVL 5

Expert Comment

by:jayeshshah
ID: 8003763
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:CleanupPing
ID: 8901247
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
 
LVL 49

Expert Comment

by:DanRollins
ID: 8964174
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
 

Accepted Solution

by:
YensidMod earned 0 total points
ID: 9104054
Question is PAQ'd and no points refunded.

YensidMod
Community Support Moderator @Experts Exchange
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month15 days, 10 hours left to enroll

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question