Using either methods, the client account must be known on the server side or an existing connection must exist between the two machines, for example connecting to the server in...

I once implemented such a notification system using a three-tier mechanism. Instead of connecting directly to the database, the client would connect to an intermediary component. The componant would dispatch...

You can use the DISTINCT keywords like

INSERT INTO _tblDupes ( ....)

SELECT DISTINCT * FROM _A a

WHERE EXISTS  (

 SELECT NULL FROM _A b

 WHERE

  b.[fld_1] = a.[fld_1]

  AND b.[fld_2] = a.[fld_2]

  AND b.[fld_3] = a.[fld_3]

  AND...