Detect if rows have changed

I want to build some pseudo-update-trigger code that will tell me if the a
row in an Access database has changed. My overall strategy is do successive
imports into SQL Server, join the tables and compare the rows. Is there a
reliable way to determine if a row has changed? I'd like to design a join
where only changed rows are returned. The rows are up to 1000 characters. I
can see that the LEN function won't be reliable. Any help would be
appreciated.I'm only interested in checking if one column in the table has changed.|||Terri
Look at virtual tables within a trigger (deleted,inserted)
"Terri" <terri@.cybernets.com> wrote in message
news:d2ui0q$7al$1@.reader2.nmix.net...
> I want to build some pseudo-update-trigger code that will tell me if the a
> row in an Access database has changed. My overall strategy is do
successive
> imports into SQL Server, join the tables and compare the rows. Is there a
> reliable way to determine if a row has changed? I'd like to design a join
> where only changed rows are returned. The rows are up to 1000 characters.
I
> can see that the LEN function won't be reliable. Any help would be
> appreciated.
>|||I tried creating a trigger on a view based on a table in a linked server.
CREATE TRIGGER
TestTrigger
ON vwComplianceTest
FOR INSERT, UPDATE, DELETE
AS
RAISERROR (50009, 16, 10)
GO
I got an error "invalid object name". The view itself is working. Also tried
to name it [dbo].[vwComplianceTest]. Is it possible to create a trigger on
a view based on a table in a linked server? Is this what you were
suggesting?
Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eXz4jZmOFHA.2728@.TK2MSFTNGP15.phx.gbl...
> Terri
> Look at virtual tables within a trigger (deleted,inserted)
>|||On Wed, 6 Apr 2005 10:36:56 -0600, Terri wrote:

>I tried creating a trigger on a view based on a table in a linked server.
>CREATE TRIGGER
>TestTrigger
>ON vwComplianceTest
>FOR INSERT, UPDATE, DELETE
>AS
>RAISERROR (50009, 16, 10)
>GO
Hi Terri,
You can't define regular triggers on views, only INSTEAD OF triggers.
I don't know if the linked server messes that up. You'll have to test
it.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)sql