Hello
I´m using MS-SQL Server 2k with a custom application connecting to it.
I need a quick and simple way to detect any change (insert, update, delete)
to my database (not just to a single table). The purpose is to notify
somehow different instances of the application about the data changes,
since they should refresh their local query results.
Is there any function, stored procedure, system database entry, etc. I can
exploit to get the job done? Can you suggest me the most suitable mechanism
to implement this?
T.I.A.
AndreA
1  2123 
"AndreA" <an************ **@teamware.it> wrote in message
news:c4******** **@grillo.cs.in terbusiness.it. .. Hello
I´m using MS-SQL Server 2k with a custom application connecting to it.
I need a quick and simple way to detect any change (insert, update,
delete) to my database (not just to a single table). The purpose is to notify
somehow different instances of the application about the data changes,
since they should refresh their local query results.
Is there any function, stored procedure, system database entry, etc. I can
exploit to get the job done? Can you suggest me the most suitable
mechanism to implement this?
T.I.A.
AndreA
You can use triggers on the tables you want to audit, or perhaps use a
product which can read the transaction log and generate an audit trail: http://www.lumigent.com/products/entegra/entegra.htm
One other option is to create a server-side trace, although personally I
would use that only as a temporary solution or to find a specific problem.
Simon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Tam Inglis |
last post by:
Got a problem.
Setting design mode on and making changes to an existing HTMLDocument makes
subsequent page changes to throw up dialog
----------------
Title has application path and file name,
"This document has been modified. Do you want to save changes?"
"Yes: Saves your changes"
"No: Discards your changes"
|
by: nic |
last post by:
hey,
I always struggle with the following:
I have an object obj with a property paydate (type = DateTime)
Now, after instantiating the object and do several things, I want too check if my paydate is still empty.
How can I do this?
I tried several things like (all with errors):
if (obj.paydate == null)
|
by: TM |
last post by:
I have a problem with the datagrid where I wanted to detect any changes to
the grid, such as a record being changed, added or deleted. So I used the
currentcellchanged method and used the code
below to update the database. But for some reason, it is detecting and
correctly updating the database on add and remove of records. But is not
writing cell changes back to the database. ANy ideas ?
'this sub will handle if a cell is changed or...
|
by: Ludovic Lemarinel |
last post by:
Hi,
I've got a Tab Control, with a lot of tabs, and a lot of controls in each
tab (textboxes, comboboxes, listviews, checkboces, etc...). As these
controls are updating a Database, I need to detect if there is any change on
any control when closing then form, or on record change .
I know which events I should use, but I can't see any property to find if my
controls have changes.
|
by: ton |
last post by:
How can I detect that the user has modified the data on the page where
several textboxes, checkboxes and dropdownlist exist.
Ton
| | |
by: Vikas |
last post by:
Hi,
I am facing a very typical problem. I have a wizard like application,
where user enters information by moving back & forth between the pages.
At the end of wizard the data is submitted into database. I store the
information entered by user on pages, in a session object and finally
destroys this session object at the end of wizard after inserting data
in database.
|
by: sukhbir |
last post by:
How to solve IE and Firefox problem? can anybody help me.
IE
When reloading a page in IE no form items are re-populated.
When going back IE repopulates all form items but resets JavaScript variables and loses the state of DIVs – meaning that any UI changes and any JavaScript state changes used to detect changes made by the user are lost when going back to a previous page.
FireFox
When reloading a page Firefox will re-populate some form...
|
by: =?Utf-8?B?U2llZ2ZyaWVkIEhlaW50emU=?= |
last post by:
I need to redundantly write C++ and C# programs to
(1) determine the input language (german, french, english...)
(2) determine changes in the input language (preferably a delegate rather
than polling!)
Can anyone guide me to the proper functions to call?
Thanks,
siegfried
|
by: saadkhan |
last post by:
I have a table named 'UnitsLocations' in which there are two columns, id of uniqueidentifier datatype and LocationXML of XML datatype. I just need to detect whether any changes have made in LocationXML column where id=someId.....
Is there any way to detect changes in XML datatype column before reading it?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
