From: anton.txt@g{oogle}mail.com   
      
   I wrote:   
      
   > Now my system uses LSNs to avoid storing redundant   
   > differential backups   
      
   For now, I have decided upon detecting changes elibible for   
   backup by the following query:   
      
     SELECT TOP 1 1 FROM fn_dblog(NULL,NULL)   
     WHERE operation IN   
           ( 'LOP_INSERT_ROWS', 'LOP_MODIFY_ROW', 'LOP_DELETE_ROWS') AND   
           AllocUnitName NOT LIKE 'sys.%'   
      
   The output of `fn_dblog' is cleared after every full and   
   diff backup, probably because the transaction log is   
   cleared, although I don't know why since my recovery model   
   is `simple' anyway, and it should not need a backup to be   
   cleared...   
      
   The major problem with this approach is that fn_dblog is an   
   undocumented function apt to change or disappear any time.   
   If anybody know how to perform an equivalent test using more   
   stable and reliable method, I shall be grateful if they   
   share it.   
      
   --   
   ()  ascii ribbon campaign -- against html e-mail   
   /\  www.asciiribbon.org   -- against proprietary attachments   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)