DP44/DataPRO_sql/SplitRecord.SqlAssembly.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'SplitRecord' and is_user_defined = 1)
DROP ASSEMBLY [SplitRecord]

GO
IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'SplitRecord' and is_user_defined = 1)
CREATE ASSEMBLY [SplitRecord]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300A0725D590000000000000000E00022200B0130000038000000060000000000008656000000200000006000000000001000200000000200000400000000000000060000000000000000A000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000345600004F00000000600000B002000000000000000000000000000000000000008000000C000000FC5400001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000008C360000002000000038000000020000000000000000000000000000200000602E72737263000000B00200000060000000040000003A0000000000000000000000000000400000402E72656C6F6300000C0000000080000000020000003E0000000000000000000000000000400000420000000000000000000000000000000068560000000000004800000002000500F82D000004270000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013300500F401000001000011000F00280700000A0F01280700000A280800000A0A730900000A0B00060C160D38BE01000008099A130400731400000613051104178D120000012516280A00000A6F0B00000A6F0C00000AA2166F0D00000A130616130738680100000011071308110845080000000500000033000000580000007E000000A3000000C5000000E80000000A01000038300100001105110611079A280E00000A2D0C110611079A280F00000A2B092300000000000000006F050000060038020100001105110611079A280E00000A2D07110611079A2B057E1000000A6F070000060038DD0000001105110611079A280E00000A2D0C110611079A281100000A2B01166F090000060038B70000001105110611079A280E00000A2D07110611079A2B057E1000000A6F0B0000060038920000001105110611079A280E00000A2D07110611079A2B057E1000000A6F0D000006002B701105110611079A280E00000A2D0C110611079A281200000A2B01166F0F000006002B4D1105110611079A280E00000A2D07110611079A2B057E1000000A6F11000006002B2B1105110611079A280E00000A2D0C
WITH PERMISSION_SET = SAFE

GO
ALTER ASSEMBLY [SplitRecord]
ADD FILE FROM 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A4453000000000200000200000053000000AC0100000000000050000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C0FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
AS N'SplitRecord.pdb'

GO