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. '


    • Related Articles

    • Convert Any Field into a Picklist

      The following script lets you convert any field into a picklist. --This script will convert any field (usually text fields) into Picklists --and generate Picklist Options from the values. GO DECLARE @Ids Table(Id NVARCHAR(MAX)) INSERT INTO @Ids ...

    • Other: Creating Unique Display Numbers

      The following script will create unique Final_ReferenceCode for all Contacts. It can be easily modified to apply to other record types. Please note that the Final_ReferenceCode that are generated are based on the data in the database. If you are ...

    • Other: Obtaining Record Counts for all Tables

      The following script will count all records in all tables. DECLARE @TableRowCounts TABLE ( [TableName] VARCHAR(128), [Action_Group] INT, [Incomplete] INT, [Complete] INT, [Total] INT ) ; INSERT INTO @TableRowCounts ( [TableName], [Action_Group], ...

    • Audit Scripts: Row Counts and Progress Monitoring

      This article shows you a script that can be used to monitor the progress of both a Backup and a Restore. It can also be used to just review row counts on all the Universal Database tables. The first code block is used to populate a SQL Server Temp ...

    • Prioritizing documents based on different criteria

      The following scripts provide examples that can be modified to apply different priorities to documents. Prioritize Documents by "Max Matter Date" All the documents in a matter are prioritized based on the Created/Modified date of the most recently ...