RE: FN-FORUM: Database Monitor (Record Changes(

date posted 22nd April 2008 16:57

Peter Scoins wrote:
> Now you have a bit of the background, I simple want an application that
> will monitor the database, allow me to merge two 'test' records together
> and tell me what changed in the database hopefully as a SQL Query(or
> Queries) so I can begin automating the process.


Sounds like a classic job for Query Analyser (part of the SQL Server client
tools), which reports all queries (optionally filtered) received by the
database. However, I think MS may have renamed QA as of SQL Server 2005
(possibly absorbed into Studio Express?) - hopefully Ben Moxon or other can
advise further.

Query Analyser takes a little getting used to by the way - it has the
ability to report everything the database does, from ADO connections to
security logins, so you have to do some filtering to get down to the
information you need. This means deciphering the sometimes confusing names
of items that can be filtered.

Cheers, Ben

--
Ben Johnson, Neogic Web Solutions
// design . development . managed hosting

w | http://www.neogic.com
t | +44 (0)1242 808 262
e | [EMAIL REMOVED]