Assembly: TestAssembly

Properties

Property	Name
Name	TestAssembly
ID	65543
Owner	dbo
CLR Name	testassembly, version=1.0.4316.37755, culture=neutral, publickeytoken=2b058e28ad39f1a5, processorarchitecture=msil
Permission Set	SAFE ACCESS
Visible
User Defined
Modify Date	10/26/2011 10:07:58 PM
Creation Date	10/26/2011 10:07:58 PM

Extended Properties

No extended properties defined.

Files

File ID	File Name
1	c:\tmp\testassembly.dll

Referenced Assemblies

No referenced assymblies.

Modules

No assembly modules defined.

Permissions

No object level permissions defined.

Objects that depend on [TestAssembly]

TestAssembly

Objects on which [TestAssembly] depends

TestAssembly

SQL

Script
CREATE ASSEMBLY [TestAssembly] AUTHORIZATION [dbo] FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006766A84E0000000000000000E00002210B010800000800000006000000000000CE270000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000074840000030040850000100000100000000010000010000000000000100000000000000000000000802700004B000000004000005803000000000000000000000010000010040000006000000C000000D82600001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000D4070000002000000008000000020000000000000000000000000000200000602E72737263000000580300000040000000040000000A0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000000E00000000000000000000000000004000004200000000000000000000000000000000B0270000000000004800000002000500EC200000EC0500000900000000000000000000000000000050200000800000000000000000000000000000000000000000000000000000000000000000000000FE3363803896EFA1DB4180831B4C5198E0248D00E12FDAA899E4F01B16CDC63492A277F328B56815D106C477C1CFCB7F3C0BECACC4F9D23443A1BD4CFA522CFE24B2A2FE2B115C60CBFA8FEC33169DCC88AFA59CEDA98E68A27D50E9B3D67FD686815BB9FDD4422BEFFB26276A63EEE357109D6B8E5E5F76968C8835E2F4F1334A00280E00000A72010000706F0F00000A002A1E02281000000A2A0042534A4201000100000000000C00000076322E302E35303732370000000005006C000000C4010000237E0000300200006C02000023537472696E6773000000009C0400001000000023555300AC040000100000002347554944000000BC0400003001000023426C6F620000000000000002000001471400000900000000FA25330016000001000000110000000200000002000000100000000B000000010000000200000000000A00010000000000060046003F0006006F005D00060086005D000600A3005D000600C2005D000600DB005D000600F4005D0006000F015D0006002A015D00060062014301060076015D000600A2018F013300B60100000600E501C50106000502C5010A004A022F020A0055022F020000000001000000000001000100010010001B002900050001000100D0200000000096004D000A000100E32000000000861857000E000100110057001200190057001200210057001200290057001200310057001200390057001200410057001200490057001200510057001700590057001200610057001C00710057002200790057000E0081005D02C900890066021200090057000E002E000B00CE002E001300E0002E001B00E0002E002300E0002E002B00CE002E003300E6002E003B00E0002E004B00E0002E005B00FE002E00630007012E006B0010010480000001000000DC107B93010000002700290000000200000000000000000000000100360000000000020000000000000000000000010023020000000000000000003C4D6F64756C653E0054657374417373656D626C792E646C6C005465737443657274436C6173730054657374417373656D626C79006D73636F726C69620053797374656D004F626A6563740048656C6C6F43657274002E63746F720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E5365727665720053716C436F6E746578740053716C50697065006765745F506970650053656E640000000B480065006C006C006F00000000004E324FDCF624A745B08D49AF54F809210008B77A5C561934E0890300000103200001042001010E0420010102052001011135042001010880A00024000004800000940000000602000000240000525341310004000001000100358CE38C84C73521210CCCF924F66D1AF063DA87CECA06FCA8667E8D12E63E91FD7CF6EE0D1019BEB072135231A935D4A72B314100DFDDD5397771044050D8743F8D7F5396980F8C1A2EE742CC093948C50D91179ED37DEC581DA468DD367201DE074534820CAFBCB76C6A3D8B6221FFB94ADB023F74574638D0972AAF2925D504000012451101000C54657374417373656D626C79000005010000000017010012436F7079726967687420C2A920203230313100000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000006766A84E00000000020000008B000000F4260000F408000052534453961F10044E98F2419963FAD5FB4B355101000000433A5C55736572735C6B7279737469616E2E7A69656A615C446F63756D656E74735C56697375616C2053747564696F20323031305C50726F6A656374735C54657374417373656D626C795C54657374417373656D626C795C6F626A5C44656275675C54657374417373656D626C792E7064620000A82700000000000000000000BE270000002000000000000000000000000000000000000000000000B02700000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000000300000000000000000000000334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001007B93DC10000001007B93DC103F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00460020000010053007400720069006E006700460069006C00650049006E0066006F0000003C020000010030003000300030003000340062003000000044000D000100460069006C0065004400650073006300720069007000740069006F006E0000000000540065007300740041007300730065006D0062006C0079000000000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0034003300310036002E00330037003700350035000000000044001100010049006E007400650072006E0061006C004E0061006D0065000000540065007300740041007300730065006D0062006C0079002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020002000320030003100310000004C00110001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000540065007300740041007300730065006D0062006C0079002E0064006C006C00000000003C000D000100500072006F0064007500630074004E0061006D00650000000000540065007300740041007300730065006D0062006C0079000000000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0034003300310036002E00330037003700350035000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0034003300310036002E003300370037003500350000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000D037000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001004000000020200308203FF06092A864886F70D010702A08203F0308203EC020101310B300906052B0E03021A05003068060A2B060104018237020104A05A30583033060A2B06010401823702010F3025030100A020A21E801C003C003C003C004F00620073006F006C006500740065003E003E003E3021300906052B0E03021A05000414A2723481EA8007427214F3685269083E6B20A418A0820215308202113082017AA003020102021034F4E4D9334D65AF4D8F60C328AD6BBB300D06092A864886F70D010105050030473145304306035504031E3C00500052004F004A0045004300540045004E0056004900530049004F004E005C006B007200790073007400690061006E002E007A00690065006A0061301E170D3131303630313138303432315A170D3132303630313030303432315A30473145304306035504031E3C00500052004F004A0045004300540045004E0056004900530049004F004E005C006B007200790073007400690061006E002E007A00690065006A006130819F300D06092A864886F70D010101050003818D003081890281810097C3141A3ECE8807A940B1E0E4B5E94B439F71D8522AD3348B2F4B117FADF5F9F4EC4B6C5EF5BD27407ACDB5240099600A3565A054C367F2FAF834690D557E61C1464AE06B44A21D13AF0532108E65D5A69F2B9D672A53535DAD8287FF43254F83337B0134568E7CEDF972D993D9DEC2232A78F508EB64212375C17F47A252B10203010001300D06092A864886F70D0101050500038181007027F9532D399968DF0CD1C918ABA26AD3D0E85959B4ABB1B53F532372E9728648B5FAE0D65CD1693B343ABB27D94B02A1A40E361FBF3F0117761AAA30DE4FABB695B8E04CBEB5AE4F25EFC985320B2931D6F52F5CA1B77062F46876E14E1721C5CBA410F96C7B674E25439D20F263E1736AD179F943DFADF0AA3464C21F4CF03182015530820151020101305B30473145304306035504031E3C00500052004F004A0045004300540045004E0056004900530049004F004E005C006B007200790073007400690061006E002E007A00690065006A0061021034F4E4D9334D65AF4D8F60C328AD6BBB300906052B0E03021A0500A0523010060A2B06010401823702010C31023000301906092A864886F70D010903310C060A2B060104018237020104302306092A864886F70D010904311604142CA557A6B9AB7E22A87035004D5D67E5D9D41153300D06092A864886F70D01010105000481802E186198A489A339182C72C4728326DDAA93ECE4351114F52C1D0A91E1E3E83EA8A18F74BF51B1CCEFFE687EE8DD77A7F1B1F074E48417E121A199A116A5111FB75F8BA5492B037E0611BAB7F5562408F8BB746F807F29E153DEB819093957843E557038C500C0777C7ADA2F3CB08C6FA100D54CD297CA739E7E872021E450690000000000 WITH PERMISSION_SET = SAFE

Script

CREATE ASSEMBLY [TestAssembly] AUTHORIZATION [dbo] FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006766A84E0000000000000000E00002210B010800000800000006000000000000CE270000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000074840000030040850000100000100000000010000010000000000000100000000000000000000000802700004B000000004000005803000000000000000000000010000010040000006000000C000000D82600001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000D4070000002000000008000000020000000000000000000000000000200000602E72737263000000580300000040000000040000000A0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000000E00000000000000000000000000004000004200000000000000000000000000000000B0270000000000004800000002000500EC200000EC0500000900000000000000000000000000000050200000800000000000000000000000000000000000000000000000000000000000000000000000FE3363803896EFA1DB4180831B4C5198E0248D00E12FDAA899E4F01B16CDC63492A277F328B56815D106C477C1CFCB7F3C0BECACC4F9D23443A1BD4CFA522CFE24B2A2FE2B115C60CBFA8FEC33169DCC88AFA59CEDA98E68A27D50E9B3D67FD686815BB9FDD4422BEFFB26276A63EEE357109D6B8E5E5F76968C8835E2F4F1334A00280E00000A72010000706F0F00000A002A1E02281000000A2A0042534A4201000100000000000C00000076322E302E35303732370000000005006C000000C4010000237E0000300200006C02000023537472696E6773000000009C0400001000000023555300AC040000100000002347554944000000BC0400003001000023426C6F620000000000000002000001471400000900000000FA25330016000001000000110000000200000002000000100000000B000000010000000200000000000A00010000000000060046003F0006006F005D00060086005D000600A3005D000600C2005D000600DB005D000600F4005D0006000F015D0006002A015D00060062014301060076015D000600A2018F013300B60100000600E501C50106000502C5010A004A022F020A0055022F020000000001000000000001000100010010001B002900050001000100D0200000000096004D000A000100E32000000000861857000E000100110057001200190057001200210057001200290057001200310057001200390057001200410057001200490057001200510057001700590057001200610057001C00710057002200790057000E0081005D02C900890066021200090057000E002E000B00CE002E001300E0002E001B00E0002E002300E0002E002B00CE002E003300E6002E003B00E0002E004B00E0002E005B00FE002E00630007012E006B0010010480000001000000DC107B93010000002700290000000200000000000000000000000100360000000000020000000000000000000000010023020000000000000000003C4D6F64756C653E0054657374417373656D626C792E646C6C005465737443657274436C6173730054657374417373656D626C79006D73636F726C69620053797374656D004F626A6563740048656C6C6F43657274002E63746F720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E5365727665720053716C436F6E746578740053716C50697065006765745F506970650053656E640000000B480065006C006C006F00000000004E324FDCF624A745B08D49AF54F809210008B77A5C561934E0890300000103200001042001010E0420010102052001011135042001010880A00024000004800000940000000602000000240000525341310004000001000100358CE38C84C73521210CCCF924F66D1AF063DA87CECA06FCA8667E8D12E63E91FD7CF6EE0D1019BEB072135231A935D4A72B314100DFDDD5397771044050D8743F8D7F5396980F8C1A2EE742CC093948C50D91179ED37DEC581DA468DD367201DE074534820CAFBCB76C6A3D8B6221FFB94ADB023F74574638D0972AAF2925D504000012451101000C54657374417373656D626C79000005010000000017010012436F7079726967687420C2A920203230313100000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000006766A84E00000000020000008B000000F4260000F408000052534453961F10044E98F2419963FAD5FB4B355101000000433A5C55736572735C6B7279737469616E2E7A69656A615C446F63756D656E74735C56697375616C2053747564696F20323031305C50726F6A656374735C54657374417373656D626C795C54657374417373656D626C795C6F626A5C44656275675C54657374417373656D626C792E7064620000A82700000000000000000000BE270000002000000000000000000000000000000000000000000000B02700000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000000300000000000000000000000334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001007B93DC10000001007B93DC103F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00460020000010053007400720069006E006700460069006C00650049006E0066006F0000003C020000010030003000300030003000340062003000000044000D000100460069006C0065004400650073006300720069007000740069006F006E0000000000540065007300740041007300730065006D0062006C0079000000000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0034003300310036002E00330037003700350035000000000044001100010049006E007400650072006E0061006C004E0061006D0065000000540065007300740041007300730065006D0062006C0079002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020002000320030003100310000004C00110001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000540065007300740041007300730065006D0062006C0079002E0064006C006C00000000003C000D000100500072006F0064007500630074004E0061006D00650000000000540065007300740041007300730065006D0062006C0079000000000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0034003300310036002E00330037003700350035000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0034003300310036002E003300370037003500350000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000D037000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001004000000020200308203FF06092A864886F70D010702A08203F0308203EC020101310B300906052B0E03021A05003068060A2B060104018237020104A05A30583033060A2B06010401823702010F3025030100A020A21E801C003C003C003C004F00620073006F006C006500740065003E003E003E3021300906052B0E03021A05000414A2723481EA8007427214F3685269083E6B20A418A0820215308202113082017AA003020102021034F4E4D9334D65AF4D8F60C328AD6BBB300D06092A864886F70D010105050030473145304306035504031E3C00500052004F004A0045004300540045004E0056004900530049004F004E005C006B007200790073007400690061006E002E007A00690065006A0061301E170D3131303630313138303432315A170D3132303630313030303432315A30473145304306035504031E3C00500052004F004A0045004300540045004E0056004900530049004F004E005C006B007200790073007400690061006E002E007A00690065006A006130819F300D06092A864886F70D010101050003818D003081890281810097C3141A3ECE8807A940B1E0E4B5E94B439F71D8522AD3348B2F4B117FADF5F9F4EC4B6C5EF5BD27407ACDB5240099600A3565A054C367F2FAF834690D557E61C1464AE06B44A21D13AF0532108E65D5A69F2B9D672A53535DAD8287FF43254F83337B0134568E7CEDF972D993D9DEC2232A78F508EB64212375C17F47A252B10203010001300D06092A864886F70D0101050500038181007027F9532D399968DF0CD1C918ABA26AD3D0E85959B4ABB1B53F532372E9728648B5FAE0D65CD1693B343ABB27D94B02A1A40E361FBF3F0117761AAA30DE4FABB695B8E04CBEB5AE4F25EFC985320B2931D6F52F5CA1B77062F46876E14E1721C5CBA410F96C7B674E25439D20F263E1736AD179F943DFADF0AA3464C21F4CF03182015530820151020101305B30473145304306035504031E3C00500052004F004A0045004300540045004E0056004900530049004F004E005C006B007200790073007400690061006E002E007A00690065006A0061021034F4E4D9334D65AF4D8F60C328AD6BBB300906052B0E03021A0500A0523010060A2B06010401823702010C31023000301906092A864886F70D010903310C060A2B060104018237020104302306092A864886F70D010904311604142CA557A6B9AB7E22A87035004D5D67E5D9D41153300D06092A864886F70D01010105000481802E186198A489A339182C72C4728326DDAA93ECE4351114F52C1D0A91E1E3E83EA8A18F74BF51B1CCEFFE687EE8DD77A7F1B1F074E48417E121A199A116A5111FB75F8BA5492B037E0611BAB7F5562408F8BB746F807F29E153DEB819093957843E557038C500C0777C7ADA2F3CB08C6FA100D54CD297CA739E7E872021E450690000000000 WITH PERMISSION_SET = SAFE