Using SQL to determine if a database has changed

[dougancil]

I have the following sql query:

ET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER PROCEDURE YourProcedure AS

insert into msbtotal.dbo.newclients
SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join
msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id =
msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is
null
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

What this does is to check to see if any new data is entered into a database but what it doesnt do is to check if there have been any modifications to the existing database information. Can anyone please assist me with a query that will look for any changes within the databases? In other words, if tcms_members.dbo.memberdata is altered or edited in any way.

Thank you

Doug