CLR upgrade error: Could not find method...for type...in assembly

• Ronzo

  Hall of Fame

  Points: 3917

  More actions

  April 17, 2017 at 9:38 am

  #401956

  Below SQL script is designed to handle both creating CLR assembly when it does not previously exist and alter it when it does exist. Works fine for create, but fails if assembly exists. Original assembly that would be updated is listed after new code; only difference is addition of function udf_Local_To_UTC.
  Error is:

  Msg 6506, Level 16, State 1, Procedure udf_Local_To_UTC, Line 2 [Batch Start Line 98]

  Could not find method 'udf_Local_To_UTC' for type 'UserDefinedFunctions' in assembly 'TMS_DB_Utils'

  Msg 208, Level 16, State 37, Procedure udf_Local_To_UTC, Line 2 [Batch Start Line 126]

  Invalid object name 'udf_Local_To_UTC'.

  What am I doing wrong?

  New assembly code:
  IF NOT EXISTS
 (SELECT
  1
 FROM
  INFORMATION_SCHEMA.SCHEMATA
 WHERE
  SCHEMA_NAME = 'tms'
 )
 EXEC
  (
  'CREATE SCHEMA
   tms
  ;'
  )
;
GO

  /*
  Deployment script for TMS_DB_Utils (CLR Database utilities)
  */

  SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON
  ;
  SET NUMERIC_ROUNDABORT OFF
  ;
  GO

  PRINT
   N'Creating [TMS_DB_Utils]...'
  ;
  GO

  IF NOT EXISTS
   (
   SELECT
    1
   FROM
    sys.assemblies
   WHERE
    name = 'TMS_DB_Utils'
   )
   CREATE ASSEMBLY
    TMS_DB_Utils
    AUTHORIZATION
     dbo
    FROM
     0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103004EE487580000000000000000E00002210B010B00000A000000060000000000007E290000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000302900004B00000000400000B802000000000000000000000000000000000000006000000C000000F82700001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000008409000000200000000A000000020000000000000000000000000000200000602E72737263000000B80200000040000000040000000C0000000000000000000000000000400000402E72656C6F6300000C000000006000000002000000100000000000000000000000000000400000420000000000000000000000000000000060290000000000004800000002000500FC200000FC0600000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133002000F0000000100001102036F0600000A6F0700000A0A062A4E03026F0800000A280900000A730A00000A512A001B3002001E00000002000011280B00000A026F0C00000A0ADE0E267201000070280D00000A0ADE00062A000001100000000000000E0E000E010000011B3001001A000000020000110F00280E00000A0ADE0E267201000070280D00000A0ADE00062A000001100000000000000A0A000E010000011E02280F00000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C000000EC010000237E000058020000BC02000023537472696E6773000000001405000018000000235553002C0500001000000023475549440000003C050000C001000023426C6F620000000000000002000001571502000900000000FA253300160000010000000D000000020000000100000005000000060000000F0000000600000002000000010000000200000000000A000100000000000600400039000A006800530006009C0089000A00C60053000600E000390006005A013B0106008E017B011F00A20100000600D101B1010600F101B1010A0037021C0206004C02390006007A0239000000000001000000000001000100010010001B000000050001000100360072000A005020000000009600A8000E0001006B20000000009600CF00150003008020000000009600E9001D000500BC20000000009600FA001D000600F4200000000086180B0124000700000001001101000002001F01000001002A0102000200330100000100670100000100700131000B01240039000B01280049000B012E0051000B01240059000B012400610053024B0161005F025001090065025C0111006E02600121000B0166016900830271016900970276012900A3027D012900A902880109000B01240020002B0033002E0023009F012E0013008D012E001B00960160002B006C0180002B006C01570183010480000000000000000000000000000000000F0200000200000000000000000000000100300000000000020000000000000000000000010047000000000000000000003C4D6F64756C653E00544D535F44425F5574696C732E646C6C0055736572446566696E656446756E6374696F6E73006D73636F726C69620053797374656D004F626A6563740053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C537472696E670044656C696D69746564537472696E67546F5461626C650053797374656D2E436F6C6C656374696F6E730049456E756D657261626C65007564665F44656C696D697465645F537472696E675F546F5F5461626C650053716C436861727300544D5346696C6C526F774D6574686F64004461746554696D65007564665F5554435F546F5F4C6F63616C007564665F4C6F63616C5F546F5F555443002E63746F7200737472696E67546F53706C69740064656C696D6974657273006F6E6556616C756500726573756C74730053797374656D2E52756E74696D652E496E7465726F705365727669636573004F7574417474726962757465005554435F54696D65004C6F63616C5F54696D650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500544D535F44425F5574696C73004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E41747472696275746500537472696E6700546F4368617241727261790053706C697400546F537472696E67006F705F496D706C696369740054696D655A6F6E65006765745F43757272656E7454696D655A6F6E6500546F4C6F63616C54696D6500506172736500546F556E6976657273616C54696D6500000000001531003900300030002F00300031002F00300031000000F2462C17D9C2C944910842D403D45E5D0008B77A5C561934E08903061109060002120D0E0E070002011C10121106000111151115032000010520010111210420010108811601000500540E044E616D651D7564665F44656C696D697465645F537472696E675F546F5F5461626C655455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A4461746141636365737300000000540E1146696C6C526F774D6574686F644E616D6510544D5346696C6C526F774D6574686F6454020F497344657465726D696E697374696301540E0F5461626C65446566696E6974696F6E1756616C7565436F6C204E564152434841522834303030290420001D030620011D0E1D030407011D0E0320000E05000111090E052001011109040100000004000012350620011115111505000111150E040701111504200011150801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000004EE4875800000000020000001C01000014280000140A000052534453F2F4C3FB22F16B498A28312F65671B9201000000763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C6F626A5C52656C656173655C544D535F44425F5574696C732E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005829000000000000000000006E290000002000000000000000000000000000000000000000000000602900000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000005C02000000000000000000005C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004BC010000010053007400720069006E006700460069006C00650049006E0066006F0000009801000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000044001100010049006E007400650072006E0061006C004E0061006D006500000054004D0053005F00440042005F005500740069006C0073002E0064006C006C00000000002800020001004C006500670061006C0043006F0070007900720069006700680074000000200000004C00110001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000054004D0053005F00440042005F005500740069006C0073002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000803900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
  ;
  GO

  ALTER ASSEMBLY
   TMS_DB_Utils
      DROP FILE ALL
      ADD FILE FROM
     0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000020000001B00000094000000000000001A000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C0FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF380000F8FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA3101380000000010000000100000000000001000FFFF04000000FFFF03000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA3101380000000010000000100000000000001100FFFF04000000FFFF0300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E31014EE4875801000000F2F4C3FB22F16B498A28312F65671B9200000000000000000100000001000000000000000000000000000000DC51330100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A799100000000000000068F2370F9B84B4E67CB376E1EE4B40E400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000006893276F1553805FB34E32CE9D7B086200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000001F7F18C5B56B6EB71013A326FB1E20810000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005A000000000000005A000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF010000005002000000763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C436F6E766572744C6F63616C54696D65546F5554432E63730000763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C636F6E766572746C6F63616C74696D65746F7574632E637300763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C436F6E76657274555443546F4C6F63616C54696D652E637300763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C636F6E76657274757463746F6C6F63616C74696D652E637300763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C44656C696D69746564537472696E67546F5461626C652E637300763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E6373000B000000010000006300000064000000C6000000280100008A010000ED010000000000000000000000000000000000000700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001BE23001D8000000EBABC5479A76D2010100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300000006000000010000001600000000000000ED010000280000001BE23001C7158CF8580000008A01000063000000ED01000065000000000000000000000028010000280000001BE230017D279D9958000000C6000000630000002801000065000000000000000000000064000000280000001BE23001D1BDB9305800000001000000630000006400000065000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000046002A110000000018010000000000000F0000000000000000000000010000060000000001000000007564665F44656C696D697465645F537472696E675F546F5F5461626C6500001600031104000000E40000000F00000000000000010000000A0024115553797374656D00160024115553797374656D2E436F6C6C656374696F6E73001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E536572766572001E00201100000000010000110000000000000000656C656D656E747300000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040000000C00000001000400020006003A002A11000000008801000000000000130000000000000000000000020000060F0000000100000000544D5346696C6C526F774D6574686F640000002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040180000C00000001000006020006003A002A1100000000B8020000000000001E0000000000000000000000030000062200000001000000007564665F5554435F546F5F4C6F63616C000000160003118C010000780200001E00000022000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E536572766572001E00201100000000020000110000000000000400435324312430303030000000020006003A000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040000000C00000001000500040280000C00000001000006020006003A002A1100000000E8030000000000001A0000000000000000000000040000064000000001000000007564665F4C6F63616C5F546F5F55544300000016000311BC020000A80300001A00000040000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E536572766572001E00201100000000020000110000000000000400435324312430303030000000020006003A000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040000000C00000001000500040280000C0000000100000602000600F20000003000000000000000010001000F00000000000000020000002400000000000000350000800D000000370000800D004F000D001D00F2000000300000000F0000000100010013000000000000000200000024000000000000004300008012000000450000800D00390009000A00F20000004800000022000000010001001E00000008000000040000003C00000000000000170000800E000000190000800F0000001B0000801C0000001D0000800D00430009000E000D00310005000600F20000004800000040000000010001001A00000010000000040000003C00000000000000100000800A000000120000800B000000140000801800000017000080110035000D0012001100350005000600F4000000180000008A01000000000000C600000000000000010000000000000020000000000000002C00000044000000640000007C0000009C000000B4000000D4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF1400000002402000065000000010000009D000000010000002D000000010000000100000001000000D500000001000000B5000000010000007D000000010000004500000001000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C0000001800000024000000300000003C00000048000000540000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002A002511000000000400000001007564665F44656C696D697465645F537472696E675F546F5F5461626C65001600291100000000040000000100303630303030303100001E002511000000001C0100000100544D5346696C6C526F774D6574686F64000016002911000000001C0100000100303630303030303200001E002511000000008C01000001007564665F5554435F546F5F4C6F63616C000016002911000000008C0100000100303630303030303300001E00251100000000BC02000001007564665F4C6F63616C5F546F5F55544300001600291100000000BC02000001003036303030303034000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF77093101010000000D00008E0E003F040F00000060000000740000002C0000003C010000000000000000000016000000190000000000EEC00000000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000C00EC0300000000000030010000030000004089D000000000000000000055736572446566696E656446756E6374696F6E730037314141414545380000002DBA2EF101000000000000000F00000000000000000000000000000000000000010000000F000000130000000000000000000000000000000000000001000000220000001E0000000000000000000000000000000000000001000000400000001A00000000000000000000000000000000000000020002000D01000000000100FFFFFFFF000000005A0000000802000000000000FFFFFFFF00000000FFFFFFFF01000300000003000000000063000000C5000000763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C44656C696D69746564537472696E67546F5461626C652E637300763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C436F6E76657274555443546F4C6F63616C54696D652E637300763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C436F6E766572744C6F63616C54696D65546F5554432E63730000FEEFFEEF010000000100000000010000000000000000000000FFFFFFFFFFFFFFFFFFFF0B00FFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E31014EE4875801000000F2F4C3FB22F16B498A28312F65671B926A0100002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C636F6E766572746C6F63616C74696D65746F7574632E6373002F7372632F66696C65732F763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C636F6E76657274757463746F6C6F63616C74696D652E6373002F7372632F66696C65732F763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E637300060000000A000000010000002F02000000000000220000000800000011000000070000000000000005000000FC0000000A0000000A000000060000008F0000000900000000000000DC5133010000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000020000000D601000038000000AB020000380000000000000090020000D80000005800000058000000580000002800000040050000740200002C000000EC0000000300000018000000060000001600000017000000070000000C0000000D0000000E00000008000000090000000A0000000B0000000F000000100000001100000012000000130000001500000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
     AS N'TMS_DB_Utils.pdb'
  ;
  GO

  /*
   Creating/Updating [tms].[udf_UTC_To_Local]
  */
  -- Not using standard EXEC tms.csp_Create_Placeholder; too complex to adapt.
  IF NOT EXISTS
   ( SELECT 1
    FROM
     INFORMATION_SCHEMA.ROUTINES
    WHERE
     ROUTINE_NAME = 'udf_UTC_To_Local'
    AND
     ROUTINE_SCHEMA = 'tms'
   )
   EXEC
    ('
    CREATE FUNCTION 
     tms.udf_UTC_To_Local
      (
      @UTC_Time
       DATETIME
      )
     RETURNS DATETIME
    AS
     EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_UTC_To_Local]
    ')
  ;
  GO

  ALTER FUNCTION
   tms.udf_UTC_To_Local
    (
    @UTC_Time
     DATETIME
    )
   RETURNS DATETIME
  AS
   EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_UTC_To_Local]
  ;
  GO

  /*
   Creating/Updating [tms].[udf_Local_To_UTC]
  */
  -- Not using standard EXEC tms.csp_Create_Placeholder; too complex to adapt.
  IF NOT EXISTS
   ( SELECT 1
    FROM
     INFORMATION_SCHEMA.ROUTINES
    WHERE
     ROUTINE_NAME = 'udf_Local_To_UTC'
    AND
     ROUTINE_SCHEMA = 'tms'
   )
   EXEC
    ('
    CREATE FUNCTION 
     tms.udf_Local_To_UTC
      (
      @Local_Time
       DATETIME
      )
     RETURNS DATETIME
    AS
     EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_Local_To_UTC]
    ')
  ;
  GO

  ALTER FUNCTION
   tms.udf_Local_To_UTC
    (
    @Local_Time
     DATETIME
    )
   RETURNS DATETIME
  AS
   EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_Local_To_UTC]
  ;
  GO

  /*
   Creating/Updating [tms].[udf_Delimited_String_To_Table]
  */
  -- Not using standard EXEC tms.csp_Create_Placeholder; too complex to adapt.
  IF NOT EXISTS
   ( SELECT 1
    FROM
     INFORMATION_SCHEMA.ROUTINES
    WHERE
     ROUTINE_NAME = 'udf_Delimited_String_To_Table'
    AND
     ROUTINE_SCHEMA = 'tms'
   )
   EXEC
    ('
    CREATE FUNCTION 
     tms.udf_Delimited_String_To_Table
      (
      @stringToSplit
       NVARCHAR (MAX)
      ,@delimiters
       NVARCHAR (MAX)
      )
     RETURNS TABLE
      (
      ValueCol
       NVARCHAR (4000)
       NULL
      )
    AS
     EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_Delimited_String_To_Table]
    ')
  ;
  GO

  ALTER FUNCTION
   tms.udf_Delimited_String_To_Table
    (
    @stringToSplit
     NVARCHAR (MAX)
    ,@delimiters
     NVARCHAR (MAX)
    )
   RETURNS TABLE
    (
      ValueCol
     NVARCHAR (4000)
     NULL
    )
  AS
   EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_Delimited_String_To_Table]
  ;
  GO

  PRINT
   N'[TMS_DB_Utils] complete.'
  ;
  GO

  Old assembly code:
  IF NOT EXISTS
 (SELECT
  1
 FROM
  INFORMATION_SCHEMA.SCHEMATA
 WHERE
  SCHEMA_NAME = 'tms'
 )
 EXEC
  (
  'CREATE SCHEMA
   tms
  ;'
  )
;
GO

  /*
  Deployment script for TMS_DB_Utils (CLR Database utilities)
  */

  SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON
  ;
  SET NUMERIC_ROUNDABORT OFF
  ;
  GO

  PRINT N'Creating [TMS_DB_Utils]...'
  ;
  GO

  IF NOT EXISTS
   (
   SELECT
    1
   FROM
    sys.assemblies
   WHERE
    name = 'TMS_DB_Utils'
   )
   CREATE ASSEMBLY [TMS_DB_Utils]
     AUTHORIZATION [dbo]
     FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300946A3B570000000000000000E00002210B010B00000A00000006000000000000FE280000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000A82800005300000000400000B802000000000000000000000000000000000000006000000C000000702700001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000000409000000200000000A000000020000000000000000000000000000200000602E72737263000000B80200000040000000040000000C0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001000000000000000000000000000004000004200000000000000000000000000000000E0280000000000004800000002000500C4200000AC0600000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133002000F0000000100001102036F0600000A6F0700000A0A062A4E03026F0800000A280900000A730A00000A512A001B3002001E00000002000011280B00000A026F0C00000A0ADE0E267201000070280D00000A0ADE00062A000001100000000000000E0E000E010000011E02280E00000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C000000CC010000237E0000380200009002000023537472696E677300000000C80400001800000023555300E0040000100000002347554944000000F0040000BC01000023426C6F620000000000000002000001571502000900000000FA253300160000010000000D000000020000000100000004000000050000000E0000000500000002000000010000000200000000000A000100000000000600400039000A006800530006009C0089000A00C60053000600E0003900060049012A01060072015F011F00860100000600B50195010600D50195010A001B02000206003002390006005E0239000000000001000000000001000100010010001B000000050001000100360072000A005020000000009600A8000E0001006B20000000009600CF00150003008020000000009600E9001D000500BC20000000008618FA0024000600000001000001000002000E010000010019010200020022010000010056013100FA0024003900FA0028004900FA002E005100FA0024005900FA002400610037024B01610043025001090049025C011100520260012100FA00660169006702710169007B027601290087027D010900FA00240020002B0033002E00130088012E001B0091012E0023009A0160002B006C0157018301048000000000000000000000000000000000F30100000200000000000000000000000100300000000000020000000000000000000000010047000000000000000000003C4D6F64756C653E00544D535F44425F5574696C732E646C6C0055736572446566696E656446756E6374696F6E73006D73636F726C69620053797374656D004F626A6563740053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C537472696E670044656C696D69746564537472696E67546F5461626C650053797374656D2E436F6C6C656374696F6E730049456E756D657261626C65007564665F44656C696D697465645F537472696E675F546F5F5461626C650053716C436861727300544D5346696C6C526F774D6574686F64004461746554696D65007564665F5554435F546F5F4C6F63616C002E63746F7200737472696E67546F53706C69740064656C696D6974657273006F6E6556616C756500726573756C74730053797374656D2E52756E74696D652E496E7465726F705365727669636573004F7574417474726962757465005554435F54696D650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500544D535F44425F5574696C73004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E41747472696275746500537472696E6700546F4368617241727261790053706C697400546F537472696E67006F705F496D706C696369740054696D655A6F6E65006765745F43757272656E7454696D655A6F6E6500546F4C6F63616C54696D6500506172736500000000001531003900300030002F00300031002F0030003100000060A84ABCCD28ED44BDE17F22811E81270008B77A5C561934E08903061109060002120D0E0E070002011C10121106000111151115032000010520010111210420010108811601000500540E044E616D651D7564665F44656C696D697465645F537472696E675F546F5F5461626C655455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A4461746141636365737300000000540E1146696C6C526F774D6574686F644E616D6510544D5346696C6C526F774D6574686F6454020F497344657465726D696E697374696301540E0F5461626C65446566696E6974696F6E1756616C7565436F6C204E564152434841522834303030290420001D030620011D0E1D030407011D0E0320000E05000111090E052001011109040100000004000012350620011115111505000111150E04070111150801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000000000946A3B5700000000020000001C0100008C2700008C09000052534453E42B9CD083B64D45A4A7F8866B067A9A05000000763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C6F626A5C52656C656173655C544D535F44425F5574696C732E706462000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000D02800000000000000000000EE280000002000000000000000000000000000000000000000000000E028000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000005C02000000000000000000005C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004BC010000010053007400720069006E006700460069006C00650049006E0066006F0000009801000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000044001100010049006E007400650072006E0061006C004E0061006D006500000054004D0053005F00440042005F005500740069006C0073002E0064006C006C00000000002800020001004C006500670061006C0043006F0070007900720069006700680074000000200000004C00110001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000054004D0053005F00440042005F005500740069006C0073002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000003900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
  ;
  GO

  ALTER ASSEMBLY [TMS_DB_Utils]
      DROP FILE ALL
      ADD FILE FROM 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000020000001F00000098000000000000001B00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020F9E7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF080618F0FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA3101380000000010000000100000000000000F00FFFF04000000FFFF0300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000001F7F18C5B56B6EB71013A326FB1E20810A0000000B000000050000000C0000000D0000000E0000000F000000110000001000000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000006893276F1553805FB34E32CE9D7B0862070000000A00000009000000040000000C0000000D0000000E0000000F00000011000000100000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000001F7F18C5B56B6EB71013A326FB1E208109000000040000000C0000000D0000000E0000000F000000110000001000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA3101380000000010000000100000000000001000FFFF04000000FFFF0300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF01000000D800000000633A5C55736572735C72636C61726B655C446F63756D656E74735C56697375616C2053747564696F20323031355C50726F6A656374735C544D535F44425F5574696C735C544D535F44425F5574696C735C44656C696D69746564537472696E67546F5461626C652E63730000633A5C75736572735C72636C61726B655C646F63756D656E74735C76697375616C2073747564696F20323031355C70726F6A656374735C746D735F64625F7574696C735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E637300040000006C0000006D00000000000000010000000300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000020000000100000002000000000000006D000000280000001BE230017D7A863258000000010000006C0000006D000000650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000546F5461626C652E637300763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E6373000B0000003A0100006C0000009C010000D8000000FF0100000000000000000000000000006D000000010000000000000007000000323031355C70726F6A656374735C746D735F64625F7574696C735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E637300040000006C0000006D0000000000000001000000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF010000006202000000633A5C55736572735C72636C61726B655C446F63756D656E74735C56697375616C2053747564696F20323031355C50726F6A656374735C544D535F44425F5574696C735C544D535F44425F5574696C735C44656C696D69746564537472696E67546F5461626C652E63730000633A5C75736572735C72636C61726B655C646F63756D656E74735C76697375616C2073747564696F20323031355C70726F6A656374735C746D735F64625F7574696C735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E637300763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C436F6E76657274555443546F4C6F63616C54696D652E637300763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C636F6E76657274757463746F6C6F63616C74696D652E637300763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C44656C696D69746564537472696E671BE23001D800000007819E8B6EB0D1010500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300000006000000010000000E000000000000006D000000280000001BE23001C7158CF858000000010000006C0000006D0000006500000000000000000000003A010000280000001BE230017D279D9958000000D80000006C0000003A010000650000000000000000000000FF010000280000001BE23001C7158CF8580000009C0100006C000000FF01000065000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000046002A110000000018010000000000000F0000000000000000000000010000060000000001000000007564665F44656C696D697465645F537472696E675F546F5F5461626C6500001600031104000000E40000000F00000000000000010000000A0024115553797374656D00160024115553797374656D2E436F6C6C656374696F6E73001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E536572766572001E00201100000000010000110000000000000000656C656D656E747300000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040000000C00000001000400020006003A002A11000000008801000000000000130000000000000000000000020000060F0000000100000000544D5346696C6C526F774D6574686F640000002E000404C93FEAC6B359D649BC250902BBABB460000000004D004400320000000401000004015C000C00000001000006020006003A002A1100000000B8020000000000001E0000000000000000000000030000062200000001000000007564665F5554435F546F5F4C6F63616C000000160003118C010000780200001E00000022000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E536572766572001E00201100000000020000110000000000000400435324312430303030000000020006003A000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040000000C0000000100050004025C000C0000000100000602000600F20000003000000000000000010001000F00000000000000020000002400000000000000350000800D000000370000800D004F000D001D00F2000000300000000F0000000100010013000000000000000200000024000000000000004300008012000000450000800D00390009000A00F20000004800000022000000010001001E00000008000000040000003C00000000000000170000800E000000190000800F0000001B0000801C0000001D0000800D00430009000E000D00310005000600F4000000100000009C01000000000000D80000000000000018000000000000002C00000044000000640000007C0000009C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF1300000001C02000065000000010000009D000000010000002D0000000100000001000000010000007D000000010000004500000001000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C0000001800000024000000300000003C00000000000000000009008C010000000000008000000001000000F8969200000000000000000055736572446566696E656446756E6374696F6E730037314141414545380000002DBA2EF101000000000000000F00000000000000000000000000000000000000010000000F0000001300000000000000000000000000000000000000020002000D01000000000100FFFFFFFF00000000220000000802000000000000FFFFFFFF00000000FFFFFFFF010001000000010000000000633A5C55736572735C72636C61726B655C446F63756D656E74735C56697375616C2053747564696F20323031355C50726F6A656374735C544D535F44425F5574696C735C544D535F44425F5574696C735C44656C696D69746564537472696E67546F5461626C652E63730000FEEFFEEF010000000100000000010000000000000000000000FFFFFFFFFFFFFFFFFFFF1000FFFFFFFFFFFFFFFFFFFF0900FFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000900000084000000F400000038000000FFFFFFFF3800000000000000FC0000008000000058000000050000000300000006000000070000000A000000090000000400000072632F66696C65732F633A5C75736572735C72636C61726B655C646F63756D656E74735C76697375616C2073747564696F20323031355C70726F6A656374735C746D735F64625F7574696C735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E6373000400000006000000010000001B00000000000000220000000800000011000000070000000A00000006000000000000000500000000000000DC513301000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001300000020000000F400000038000000BB0100003800000000000000FC00000080000000580000002800000024020000440200002C0000007C00000003000000130000000600000012000000070000000A0000000B00000008000000090000000C0000000D0000000E0000000F000000110000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002A002511000000000400000001007564665F44656C696D697465645F537472696E675F546F5F5461626C65001600291100000000040000000100303630303030303100001E002511000000001C0100000100544D5346696C6C526F774D6574686F64000016002911000000001C0100000100303630303030303200001E002511000000008C01000001007564665F5554435F546F5F4C6F63616C000016002911000000008C0100000100303630303030303300002E6373000400000006000000010000001B00000000000000220000000800000011000000070000000A00000006000000000000000500000000000000DC5133010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF10000000000000000616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F633A5C75736572735C72636C61726B655C646F63756D656E74735C76697375616C2073747564696F20323031355C70726F6A656374735C746D735F64625F7574696C735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E6373000400000006000000010000001B00000000000000220000000800000011000000070000000A00000006000000000000000500000000000000DC51330100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF77093101050000000C00008E0D001F040E00000060000000580000002C00000040010000000000000000000016000000190000000000EEC00000000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000B00BC02000000000000D800000002000000A0297400000000000000000055736572446566696E656446756E6374696F6E730037314141414545380000002DBA2EF101000000000000000F00000000000000000000000000000000000000010000000F000000130000000000000000000000000000000000000001000000220000001E00000000000000000000000000000000000000020002000D01000000000100FFFFFFFF00000000400000000802000000000000FFFFFFFF00000000FFFFFFFF01000200000002006B000000CE000000633A5C55736572735C72636C61726B655C446F63756D656E74735C56697375616C2053747564696F20323031355C50726F6A656374735C544D535F44425F5574696C735C544D535F44425F5574696C735C44656C696D69746564537472696E67546F5461626C652E637300763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C44656C696D69746564537472696E67546F5461626C652E637300763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C436F6E76657274555443546F4C6F63616C54696D652E637300FEEFFEEF010000000100000000010000000000000000000000FFFFFFFFFFFFFFFFFFFF0A00FFFFFFFFFFFFFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E31016056A95605000000E42B9CD083B64D45A4A7F8866B067A9A730100002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F633A5C75736572735C72636C61726B655C646F63756D656E74735C76697375616C2073747564696F20323031355C70726F6A656374735C746D735F64625F7574696C735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E6373002F7372632F66696C65732F763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C636F6E76657274757463746F6C6F63616C74696D652E6373002F7372632F66696C65732F763A5C72636C61726B655F6F72626361645F64617461626173655F656E67675C6F72626361645F69695C64617461626173655C63735F66696C65735C746D735F64625F7574696C735C64656C696D69746564737472696E67746F7461626C652E637300060000000A000000010000006E020000000000001100000007000000000000000500000005010000090000000A000000060000002200000008000000980000001100000000000000DC5133010000000000000000000000000000000000000000000000000000000000000000001200000044000000DF01000038000000930200003800000000000000A2020000D8000000580000005800000028000000B00300005C0200002C000000B4000000FFFFFFFFFFFFFFFF580000001300000019000000060000001700000018000000070000000D0000000C0000000E00000004000000080000000B0000000F0000001000000011000000120000001600000015000000050000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 AS N'TMS_DB_Utils.pdb'
  ;
  GO

  /*
   Creating/Updating [tms].[udf_UTC_To_Local]
  */
  -- Not using standard EXEC tms.csp_Create_Placeholder; too complex to adapt.
  IF NOT EXISTS
   ( SELECT 1
    FROM
     INFORMATION_SCHEMA.ROUTINES
    WHERE
     ROUTINE_NAME = 'udf_UTC_To_Local'
    AND
     ROUTINE_SCHEMA = 'tms'
   )
   EXEC
    ('
    CREATE FUNCTION 
     tms.udf_UTC_To_Local
      (
      @UTC_Time
       DATETIME
      )
     RETURNS DATETIME
    AS
     EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_UTC_To_Local]
    ')
  ;
  GO

  ALTER FUNCTION
   tms.udf_UTC_To_Local
    (
    @UTC_Time
     DATETIME
    )
   RETURNS DATETIME
  AS
   EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_UTC_To_Local]
  ;
  GO

  /*
   Creating/Updating [tms].[udf_Delimited_String_To_Table]
  */
  -- Not using standard EXEC tms.csp_Create_Placeholder; too complex to adapt.
  IF NOT EXISTS
   ( SELECT 1
    FROM
     INFORMATION_SCHEMA.ROUTINES
    WHERE
     ROUTINE_NAME = 'udf_Delimited_String_To_Table'
    AND
     ROUTINE_SCHEMA = 'tms'
   )
   EXEC
    ('
    CREATE FUNCTION 
     tms.udf_Delimited_String_To_Table
      (
      @stringToSplit
       NVARCHAR (MAX)
      ,@delimiters
       NVARCHAR (MAX)
      )
     RETURNS TABLE
      (
      ValueCol
       NVARCHAR (4000)
       NULL
      )
    AS
     EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_Delimited_String_To_Table]
    ')
  ;
  GO

  ALTER FUNCTION
   tms.udf_Delimited_String_To_Table
    (
    @stringToSplit
     NVARCHAR (MAX)
    ,@delimiters
     NVARCHAR (MAX)
    )
   RETURNS TABLE
    (
      ValueCol
     NVARCHAR (4000)
     NULL
    )
  AS
   EXTERNAL NAME [TMS_DB_Utils].[UserDefinedFunctions].[udf_Delimited_String_To_Table]
  ;
  GO

  PRINT N'[TMS_DB_Utils] complete.'
  ;
  GO
  

  ---

  Have Fun!
  Ronzo
  

• Phil Parkin

  SSC Guru

  Points: 246695

  More actions

  April 17, 2017 at 9:49 am

  #1938322

  You mention the word 'upgrade' in the message's subject. What is being upgraded here?

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

• Ronzo

  Hall of Fame

  Points: 3917

  More actions

  April 17, 2017 at 10:56 am

  #1938341

  If the assembly does not exist, I create it. The I use ALTER ASSEMBLY to "upgrade" the existing assembly with the latest code. Is this not how it is done?

  ---

  Have Fun!
  Ronzo
  

• sgmunson

  SSC Guru

  Points: 110639

  More actions

  April 17, 2017 at 12:44 pm

  #1938359

  Yes, but if the assembly requires the function, then you just have that part of the script "out of order".

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)

• Ronzo

  Hall of Fame

  Points: 3917

  More actions

  April 17, 2017 at 1:58 pm

  #1938369

  Found my problem. I misunderstood the purpose of the Visual Studio generated script. I assumed the CREATE ASSEMBLY was to establish a "placeholder" and that the subsequent ALTER ASSEMBLY contained the actual binary. Instead the binary I needed was in the CREATE ASSEMBLY and the ALTER ASSEMBLY was a "debug" binary that I don't actually need to field. Thus I have "fixed" my problem by changing my script to the following:
  IF NOT EXISTS
 (
 SELECT
  1
 FROM
  sys.assemblies
 WHERE
  name = 'TMS_DB_Utils'
 )
 CREATE ASSEMBLY
  TMS_DB_Utils
  AUTHORIZATION
   dbo
  FROM
   0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103004EE487580000000000000000E00002210B010B00000A000000060000000000007E290000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000302900004B00000000400000B802000000000000000000000000000000000000006000000C000000F82700001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000008409000000200000000A000000020000000000000000000000000000200000602E72737263000000B80200000040000000040000000C0000000000000000000000000000400000402E72656C6F6300000C000000006000000002000000100000000000000000000000000000400000420000000000000000000000000000000060290000000000004800000002000500FC200000FC0600000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133002000F0000000100001102036F0600000A6F0700000A0A062A4E03026F0800000A280900000A730A00000A512A001B3002001E00000002000011280B00000A026F0C00000A0ADE0E267201000070280D00000A0ADE00062A000001100000000000000E0E000E010000011B3001001A000000020000110F00280E00000A0ADE0E267201000070280D00000A0ADE00062A000001100000000000000A0A000E010000011E02280F00000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C000000EC010000237E000058020000BC02000023537472696E6773000000001405000018000000235553002C0500001000000023475549440000003C050000C001000023426C6F620000000000000002000001571502000900000000FA253300160000010000000D000000020000000100000005000000060000000F0000000600000002000000010000000200000000000A000100000000000600400039000A006800530006009C0089000A00C60053000600E000390006005A013B0106008E017B011F00A20100000600D101B1010600F101B1010A0037021C0206004C02390006007A0239000000000001000000000001000100010010001B000000050001000100360072000A005020000000009600A8000E0001006B20000000009600CF00150003008020000000009600E9001D000500BC20000000009600FA001D000600F4200000000086180B0124000700000001001101000002001F01000001002A0102000200330100000100670100000100700131000B01240039000B01280049000B012E0051000B01240059000B012400610053024B0161005F025001090065025C0111006E02600121000B0166016900830271016900970276012900A3027D012900A902880109000B01240020002B0033002E0023009F012E0013008D012E001B00960160002B006C0180002B006C01570183010480000000000000000000000000000000000F0200000200000000000000000000000100300000000000020000000000000000000000010047000000000000000000003C4D6F64756C653E00544D535F44425F5574696C732E646C6C0055736572446566696E656446756E6374696F6E73006D73636F726C69620053797374656D004F626A6563740053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C537472696E670044656C696D69746564537472696E67546F5461626C650053797374656D2E436F6C6C656374696F6E730049456E756D657261626C65007564665F44656C696D697465645F537472696E675F546F5F5461626C650053716C436861727300544D5346696C6C526F774D6574686F64004461746554696D65007564665F5554435F546F5F4C6F63616C007564665F4C6F63616C5F546F5F555443002E63746F7200737472696E67546F53706C69740064656C696D6974657273006F6E6556616C756500726573756C74730053797374656D2E52756E74696D652E496E7465726F705365727669636573004F7574417474726962757465005554435F54696D65004C6F63616C5F54696D650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500544D535F44425F5574696C73004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E41747472696275746500537472696E6700546F4368617241727261790053706C697400546F537472696E67006F705F496D706C696369740054696D655A6F6E65006765745F43757272656E7454696D655A6F6E6500546F4C6F63616C54696D6500506172736500546F556E6976657273616C54696D6500000000001531003900300030002F00300031002F00300031000000F2462C17D9C2C944910842D403D45E5D0008B77A5C561934E08903061109060002120D0E0E070002011C10121106000111151115032000010520010111210420010108811601000500540E044E616D651D7564665F44656C696D697465645F537472696E675F546F5F5461626C655455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A4461746141636365737300000000540E1146696C6C526F774D6574686F644E616D6510544D5346696C6C526F774D6574686F6454020F497344657465726D696E697374696301540E0F5461626C65446566696E6974696F6E1756616C7565436F6C204E564152434841522834303030290420001D030620011D0E1D030407011D0E0320000E05000111090E052001011109040100000004000012350620011115111505000111150E040701111504200011150801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000004EE4875800000000020000001C01000014280000140A000052534453F2F4C3FB22F16B498A28312F65671B9201000000763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C6F626A5C52656C656173655C544D535F44425F5574696C732E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005829000000000000000000006E290000002000000000000000000000000000000000000000000000602900000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000005C02000000000000000000005C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004BC010000010053007400720069006E006700460069006C00650049006E0066006F0000009801000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000044001100010049006E007400650072006E0061006C004E0061006D006500000054004D0053005F00440042005F005500740069006C0073002E0064006C006C00000000002800020001004C006500670061006C0043006F0070007900720069006700680074000000200000004C00110001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000054004D0053005F00440042005F005500740069006C0073002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000803900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
;
GO

  /*
   Only needed to clean up previously inadvertant deployment of debug files, which would
   otherwise block use of the second ALTER ASSEMBLY.
  */
  ALTER ASSEMBLY
   TMS_DB_Utils
      DROP FILE ALL
  ;
  GO

  /*
   This is same exact binary as that used above in CREATE ASSEMBLY.
  */
  ALTER ASSEMBLY
   TMS_DB_Utils
    FROM
     0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103004EE487580000000000000000E00002210B010B00000A000000060000000000007E290000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000302900004B00000000400000B802000000000000000000000000000000000000006000000C000000F82700001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000008409000000200000000A000000020000000000000000000000000000200000602E72737263000000B80200000040000000040000000C0000000000000000000000000000400000402E72656C6F6300000C000000006000000002000000100000000000000000000000000000400000420000000000000000000000000000000060290000000000004800000002000500FC200000FC0600000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133002000F0000000100001102036F0600000A6F0700000A0A062A4E03026F0800000A280900000A730A00000A512A001B3002001E00000002000011280B00000A026F0C00000A0ADE0E267201000070280D00000A0ADE00062A000001100000000000000E0E000E010000011B3001001A000000020000110F00280E00000A0ADE0E267201000070280D00000A0ADE00062A000001100000000000000A0A000E010000011E02280F00000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C000000EC010000237E000058020000BC02000023537472696E6773000000001405000018000000235553002C0500001000000023475549440000003C050000C001000023426C6F620000000000000002000001571502000900000000FA253300160000010000000D000000020000000100000005000000060000000F0000000600000002000000010000000200000000000A000100000000000600400039000A006800530006009C0089000A00C60053000600E000390006005A013B0106008E017B011F00A20100000600D101B1010600F101B1010A0037021C0206004C02390006007A0239000000000001000000000001000100010010001B000000050001000100360072000A005020000000009600A8000E0001006B20000000009600CF00150003008020000000009600E9001D000500BC20000000009600FA001D000600F4200000000086180B0124000700000001001101000002001F01000001002A0102000200330100000100670100000100700131000B01240039000B01280049000B012E0051000B01240059000B012400610053024B0161005F025001090065025C0111006E02600121000B0166016900830271016900970276012900A3027D012900A902880109000B01240020002B0033002E0023009F012E0013008D012E001B00960160002B006C0180002B006C01570183010480000000000000000000000000000000000F0200000200000000000000000000000100300000000000020000000000000000000000010047000000000000000000003C4D6F64756C653E00544D535F44425F5574696C732E646C6C0055736572446566696E656446756E6374696F6E73006D73636F726C69620053797374656D004F626A6563740053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C537472696E670044656C696D69746564537472696E67546F5461626C650053797374656D2E436F6C6C656374696F6E730049456E756D657261626C65007564665F44656C696D697465645F537472696E675F546F5F5461626C650053716C436861727300544D5346696C6C526F774D6574686F64004461746554696D65007564665F5554435F546F5F4C6F63616C007564665F4C6F63616C5F546F5F555443002E63746F7200737472696E67546F53706C69740064656C696D6974657273006F6E6556616C756500726573756C74730053797374656D2E52756E74696D652E496E7465726F705365727669636573004F7574417474726962757465005554435F54696D65004C6F63616C5F54696D650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500544D535F44425F5574696C73004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E41747472696275746500537472696E6700546F4368617241727261790053706C697400546F537472696E67006F705F496D706C696369740054696D655A6F6E65006765745F43757272656E7454696D655A6F6E6500546F4C6F63616C54696D6500506172736500546F556E6976657273616C54696D6500000000001531003900300030002F00300031002F00300031000000F2462C17D9C2C944910842D403D45E5D0008B77A5C561934E08903061109060002120D0E0E070002011C10121106000111151115032000010520010111210420010108811601000500540E044E616D651D7564665F44656C696D697465645F537472696E675F546F5F5461626C655455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A4461746141636365737300000000540E1146696C6C526F774D6574686F644E616D6510544D5346696C6C526F774D6574686F6454020F497344657465726D696E697374696301540E0F5461626C65446566696E6974696F6E1756616C7565436F6C204E564152434841522834303030290420001D030620011D0E1D030407011D0E0320000E05000111090E052001011109040100000004000012350620011115111505000111150E040701111504200011150801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000004EE4875800000000020000001C01000014280000140A000052534453F2F4C3FB22F16B498A28312F65671B9201000000763A5C72636C61726B655F4F72624341445F44617461626173655F456E67675C4F72624341445F49495C64617461626173655C63735F66696C65735C544D535F44425F5574696C735C6F626A5C52656C656173655C544D535F44425F5574696C732E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005829000000000000000000006E290000002000000000000000000000000000000000000000000000602900000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000005C02000000000000000000005C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004BC010000010053007400720069006E006700460069006C00650049006E0066006F0000009801000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000044001100010049006E007400650072006E0061006C004E0061006D006500000054004D0053005F00440042005F005500740069006C0073002E0064006C006C00000000002800020001004C006500670061006C0043006F0070007900720069006700680074000000200000004C00110001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000054004D0053005F00440042005F005500740069006C0073002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000803900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
  ;
  GO
  

  ---

  Have Fun!
  Ronzo