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