Clear all Result_Ids

Clear all Result_Ids

  1. /* 
  2.     WARNING!!! THIS IS A DANGEROUS SCRIPT!!!
  3.     MAKE SURE YOU ARE USING THE RIGHT DATABASE!!!
  4.     This script will clear out all Result_Ids in a database.
  5. */

  7. USE [DATABASENAME];
  8. EXEC sp_MSforeachtable 
  9. 'UPDATE
  10.     ?
  11. SET
  12.     Action_Group = 5000,
  13.     Action_Priority = 5000,
  14.     Action_IsRunning = 0,
  15.     
  16.     Result_Agent = '''',
  17.     Result_Warning = '''',
  18.     Result_Started_At = null,
  19.     Result_Duration = null,
  20.     Result_View_Url = '''',
  21.     Result_Content = '''',
  22.     Result_Content_Url = '''',
  23.     Result_Id = '''',
  24.     Result_ReferenceCode = '''',
  25.     
  26.     Progress_Agent = '''',
  27.     Progress_Started_At = null,
  28.     Progress_Duration = null,
  29.     Progress_Log = '''',

  31.     Error_Agent = '''',
  32.     Error_Date = null,
  33.     Error_ReferenceCode = '''',
  34.     Error_Subject = '''',
  35.     Error_Description = '''',

  37.     Log_History = '''',
  38.     Log_Updated_At = null,
  39.     Log_Duration_Total = null
  40. '