· 8 years ago · Sep 25, 2017, 12:12 AM
1/*
2 This script creates a CLR stored procedure and its assembly on a database that will let you search for a
3 substring on all columns of all tables of all types except 'binary', 'varbinary', 'bit', 'timestamp',
4 'image', 'sql_variant', and 'hierarchyid'. This was made as a CLR stored proc to take advantage of explicit
5 parallelism to make the search a lot faster. Be aware that this will use many cores so only use this for
6 occasional DBA work. This has the potential to cause a DDoS type of situation if broad searches with many
7 results are hammered into the server, since each request can try to parallelize its search. An optional
8 parameter exists to limit parallelism to a set number of cores. You can also set filters on the tables
9 or columns to search (see examples below). Results are returned as XML rows.
10
11 To install you need owner rights. Also, because SQL Server doesn't allow secondary CLR threads access to
12 the stored procedure context, we extract the connection string from the first context connection we make.
13 This works fine, but only if you are connected with a trusted connection (using a Windows account).
14
15 ------------------------------------------------------------------
16 -- CLR access must be enabled on the instance for this to work. --
17 ------------------------------------------------------------------
18 -- sp_configure 'show advanced options', 1; --
19 -- GO --
20 -- RECONFIGURE; --
21 -- GO --
22 -- sp_configure 'clr enabled', 1; --
23 -- GO --
24 -- RECONFIGURE; --
25 -- GO --
26 ------------------------------------------------------------------
27
28 -----------------------------------------------------------------------------------
29 -- Database need to be flagged thrustworthy to be able to access CLR assemblies. --
30 -----------------------------------------------------------------------------------
31 -- ALTER DATABASE [AdventureWorks] SET TRUSTWORTHY ON; --
32 -----------------------------------------------------------------------------------
33
34 Example usages:
35 ---------------
36 Using all available processors on the server:
37 EXEC [dbo].[SearchAllTables] @valueSearchTerm = 'john'
38
39 Limiting the server to 4 concurrent threads:
40 EXEC [dbo].[SearchAllTables] @valueSearchTerm = 'john', @maxDegreeOfParallelism = 4
41
42 Limiting search to table names and/or column names containing some search term:
43 EXEC [dbo].[SearchAllTables] @valueSearchTerm = 'john', @tablesSearchTerm = 'person', @columnsSearchTerm = 'address'
44
45 Limiting search results to the first row of each table where the terms are found:
46 EXEC [dbo].[SearchAllTables] @valueSearchTerm = 'john', @getOnlyFirstRowPerTable = 1
47
48 Limiting the search to the schema only automatically returns only the first row for each table:
49 EXEC [dbo].[SearchAllTables] @tablesSearchTerm = 'person'
50
51 Capturing results into temporary table and sorting:
52 CREATE TABLE #temp (Result NVARCHAR(MAX));
53 INSERT INTO #temp
54 EXEC [dbo].[SearchAllTables] @valueSearchTerm = 'john';
55 SELECT * FROM #temp ORDER BY Result ASC;
56 DROP TABLE #temp;
57
58 Example results:
59 ----------------
60 <Person.Contact ContactID="19200" NameStyle="0" FirstName="Shannon" MiddleName="L" LastName="Johnston" EmailAddress="shannon27@adventure-works.com" EmailPromotion="2" Phone="1 (11) 500 555-0191" PasswordHash="zeQJlxahQsrCfTEgGy+ZeziLbngh3X+C8KsFla+YS/s=" PasswordSalt="kk7z2cU=" rowguid="FACA95BA-5111-4C15-86B5-7974E5CEC5CC" ModifiedDate="2004-05-05T00:00:00" />
61 <Person.Contact ContactID="16950" NameStyle="0" FirstName="Samuel" MiddleName="B" LastName="Johnston" EmailAddress="samuel59@adventure-works.com" EmailPromotion="1" Phone="590-555-0111" PasswordHash="k87k1wrrdRbs1G5vnlLR68Y8zaJouoUQnu0avIBNoPo=" PasswordSalt="ZeXAfxY=" rowguid="55BEF9C4-0C1C-4618-AA32-01DD593EF19A" ModifiedDate="2003-12-02T00:00:00" />
62 <Person.Contact ContactID="13172" NameStyle="0" FirstName="Joanna" MiddleName="L" LastName="Johnston" EmailAddress="joanna4@adventure-works.com" EmailPromotion="0" Phone="1 (11) 500 555-0173" PasswordHash="t6y2TYEB9YC/F70qs5q8yVJ03xEn3jlKNv505MSVRq0=" PasswordSalt="ZkZlTTE=" rowguid="DD9AED24-4B1A-4F3C-A3D6-5DEDFCF1FF46" ModifiedDate="2004-02-28T00:00:00" />
63 <Person.Contact ContactID="12977" NameStyle="0" FirstName="Richard" LastName="Johnston" EmailAddress="richard62@adventure-works.com" EmailPromotion="0" Phone="577-555-0182" PasswordHash="mvhsTKyWnChH1/YtWZcWVdQR3wNqw1IP6B3PmkPmeLg=" PasswordSalt="2pLavx8=" rowguid="874A1D93-A5A8-40A6-993D-269361180812" ModifiedDate="2003-08-30T00:00:00" />
64 <Person.Contact ContactID="11104" NameStyle="0" FirstName="Tamara" MiddleName="H" LastName="Johnston" EmailAddress="tamara22@adventure-works.com" EmailPromotion="2" Phone="1 (11) 500 555-0194" PasswordHash="pKXkE6v7csoTsLjBsnlWr/rU1tyfO9Uwg7VfVjt9mn8=" PasswordSalt="wiS0a3g=" rowguid="3EE4CA24-D41A-42BA-AB1B-844675290960" ModifiedDate="2004-01-02T00:00:00" />
65 <Person.Contact ContactID="10230" NameStyle="0" FirstName="Julia" LastName="Johnston" EmailAddress="julia23@adventure-works.com" EmailPromotion="1" Phone="921-555-0148" PasswordHash="T5iGadQPaqkr1893VCbH84U2jgHTbUg7xbJZaDqxekg=" PasswordSalt="LmZ54sU=" rowguid="6CF4C953-0F80-4B21-BD0D-447C274D4F3D" ModifiedDate="2004-01-16T00:00:00" />
66 <Person.Contact ContactID="4038" NameStyle="0" FirstName="Charles" LastName="Johnston" EmailAddress="charles4@adventure-works.com" EmailPromotion="1" Phone="540-555-0148" PasswordHash="DtHZYYecnjZvdX6PnpBERYKCcr39wwhIknFRIvoXAKo=" PasswordSalt="tF0D4lM=" rowguid="5C50CF91-DD4E-45A5-9B41-181651101450" ModifiedDate="2003-12-02T00:00:00" />
67 <Person.Contact ContactID="1481" NameStyle="0" FirstName="Louis" LastName="Johnston" EmailAddress="louis1@adventure-works.com" EmailPromotion="0" Phone="146-555-0100" PasswordHash="gExiK1VagDSBxR69Jx7gMNbCduelIhFpR7nOkW1Gvwc=" PasswordSalt="9qqBXSs=" rowguid="99AE51D0-3FDF-4A9F-9A1C-A898A5D06998" ModifiedDate="1999-03-08T00:00:00" />
68 <Person.Contact ContactID="444" NameStyle="0" Title="Ms." FirstName="Tamara" LastName="Johnston" EmailAddress="tamara0@adventure-works.com" EmailPromotion="0" Phone="1 (11) 500 555-0187" PasswordHash="+9TZ+VsWTxh0NLLbYHqBzKdjUoCflp0eT66ku220+5A=" PasswordSalt="BgdCHh4=" rowguid="F391731B-15F6-4D6D-AF8E-EFA1525AB8D2" ModifiedDate="2003-09-01T00:00:00" />
69 <Person.Contact ContactID="39" NameStyle="0" Title="Mr." FirstName="Tom" MiddleName="H" LastName="Johnston" EmailAddress="tom1@adventure-works.com" EmailPromotion="1" Phone="883-555-0177" PasswordHash="WonAzK7XRDoFn66D6qVMzma60dA96LHtk2lz7a28mI4=" PasswordSalt="0lp7vWg=" rowguid="BC8FC7EC-3A2F-4436-8BEA-1A08AE3A6E39" ModifiedDate="2001-08-01T00:00:00" />
70
71 Source code of the CLR assembly:
72 --------------------------------
73 using System;
74 using System.Data;
75 using System.Data.SqlClient;
76 using System.Collections.Concurrent;
77 using System.Threading.Tasks;
78 using System.Xml;
79 using Microsoft.SqlServer.Server;
80
81 public partial class StoredProcedures
82 {
83 [SqlProcedure]
84 public static void SearchAllTables(string valueSearchTerm = "", string tablesSearchTerm = "", string columnsSearchTerm = "", bool getOnlyFirstRowPerTable = false, int maxDegreeOfParallelism = 0)
85 {
86 var qGetTables = @"SELECT QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) AS TableName "
87 + @"FROM INFORMATION_SCHEMA.TABLES "
88 + @"WHERE TABLE_TYPE = 'BASE TABLE' "
89 + @" AND OBJECTPROPERTY(OBJECT_ID(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)), 'IsMSShipped') = 0 ";
90
91 if (tablesSearchTerm != "") qGetTables += $@"AND TABLE_NAME + TABLE_SCHEMA LIKE '%{tablesSearchTerm}%'";
92
93 var qGetColumns = @"SELECT QUOTENAME(COLUMN_NAME) AS ColName "
94 + @"FROM INFORMATION_SCHEMA.COLUMNS "
95 + @"WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2) "
96 + @" AND TABLE_NAME = PARSENAME(@TableName, 1) "
97 + @" AND DATA_TYPE NOT IN ('binary', 'varbinary', 'bit', 'timestamp', 'image', 'sql_variant', 'hierarchyid') ";
98
99 if (columnsSearchTerm != "") qGetColumns += $@"AND COLUMN_NAME LIKE '%{columnsSearchTerm}%'";
100
101 var qGetConnStr = @"SELECT 'Server=' + @@SERVERNAME + ';Database=' + DB_NAME() + ';Trusted_Connection=True;Enlist=False;'";
102
103 var connectionString = "";
104
105 var dtTables = new DataTable();
106 using (var conn = new SqlConnection("context connection=true"))
107 {
108 conn.Open();
109
110 connectionString = (new SqlCommand(qGetConnStr, conn)).ExecuteScalar().ToString();
111
112 using (var cmd = new SqlCommand(qGetTables, conn))
113 {
114 using (var adapter = new SqlDataAdapter(cmd))
115 adapter.Fill(dtTables);
116 }
117 }
118
119 var subQueryResults = new ConcurrentBag<string>();
120
121 Parallel.ForEach(
122 dtTables.Select(),
123 new ParallelOptions() { MaxDegreeOfParallelism = (maxDegreeOfParallelism == 0) ? Environment.ProcessorCount
124 : maxDegreeOfParallelism },
125 row =>
126 {
127 var tableName = row[0].ToString();
128
129 using (var conn = new SqlConnection(connectionString))
130 {
131 conn.Open();
132
133 var whereClause = "";
134 using (var cmd = new SqlCommand(qGetColumns.Replace("@TableName", $@"'{tableName}'"), conn))
135 {
136 using (var reader = cmd.ExecuteReader())
137 {
138 while (reader.Read())
139 whereClause += $@"ISNULL(CONVERT(NVARCHAR(MAX), {reader.GetSqlString(0).Value}), '') + ";
140 }
141 }
142
143 var qTopOne = (getOnlyFirstRowPerTable || valueSearchTerm == "") ? "TOP 1" : "";
144 using (var cmd = new SqlCommand($@"SELECT {qTopOne} * FROM {tableName} WHERE {whereClause} '' LIKE '%{valueSearchTerm}%' FOR XML AUTO;", conn))
145 {
146 var cmdRes = "";
147 using (var reader = cmd.ExecuteReader())
148 {
149 while (reader.Read()) cmdRes += reader.GetSqlString(0).Value;
150
151 if (cmdRes != "")
152 {
153 var xmldoc = new XmlDocument();
154 xmldoc.LoadXml("<doc>" + cmdRes + "</doc>");
155 var nodes = xmldoc.SelectNodes("(//doc/*)");
156 foreach (XmlNode node in nodes) subQueryResults.Add(node.OuterXml);
157 }
158 }
159 }
160 }
161 });
162
163 var recmeta = new SqlMetaData("FoundRow", SqlDbType.NVarChar, SqlMetaData.Max);
164 var rec = new SqlDataRecord(recmeta);
165
166 SqlContext.Pipe.SendResultsStart(rec);
167 foreach (var qres in subQueryResults.ToArray())
168 {
169 rec.SetString(0, qres);
170 SqlContext.Pipe.SendResultsRow(rec);
171 }
172 SqlContext.Pipe.SendResultsEnd();
173 }
174 }
175*/*/
176
177SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
178SET NUMERIC_ROUNDABORT OFF;
179GO
180
181PRINT N'Removing previous versions...';
182GO
183
184DROP PROCEDURE [dbo].[SearchAllTables]
185DROP ASSEMBLY [SqlUtils]
186GO
187
188PRINT N'Adding CLR assembly [SqlUtils]...';
189GO
190
191CREATE ASSEMBLY [SqlUtils]
192 AUTHORIZATION [dbo]
193 FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300C245C8590000000000000000E00022200B013000001A0000000600000000000066380000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000143800004F00000000400000A802000000000000000000000000000000000000006000000C000000DC3600001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000006C18000000200000001A000000020000000000000000000000000000200000602E72737263000000A80200000040000000040000001C0000000000000000000000000000400000402E72656C6F6300000C000000006000000002000000200000000000000000000000000000400000420000000000000000000000000000000048380000000000004800000002000500EC240000F011000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001B300400C20100000100001173030000060A06057D0300000406027D040000040072010000700B0372EA010070280600000A130611062C120772EC01007003280700000A280800000A0B0672420200707D020000040472EA010070280600000A130711072C1C06067B02000004725F04007004280700000A280800000A7D0200000472990400700C0672EA0100707D01000004730900000A0D7266050070730A00000A13080011086F0B00000A0006081108730C00000A6F0D00000A6F0E00000A7D01000004071108730C00000A1309001109730F00000A130A110A096F1000000A26DE0D110A2C08110A6F1100000A00DC00DE0D11092C0811096F1100000A00DC00DE0D11082C0811086F1100000A00DC06731200000A7D05000004096F1300000A731400000A250E042C040E042B05281500000A6F1600000A0006FE0604000006731700000A280100002B2672960500701F0C281900000A731A00000A1304178D0800000125161104A2731B00000A1305281C00000A11056F1D00000A0000067B050000046F1E00000A130B16130C2B27110B110C9A130D00110516110D6F1F00000A00281C00000A11056F2000000A0000110C1758130C110C110B8E6932D1281C00000A6F2100000A002A0000012800000200CE000BD9000D000000000200C40025E9000D000000000200990060F9000D000000002202282200000A002A0000001B300500F5010000020000110003166F2300000A6F0E00000A0A027B01000004730A00000A0B00076F0B00000A0072EA0100700C027B0200000472A805007072BE05007006280700000A6F2400000A07730C00000A13040011046F2500000A1305002B220872CA0500701105166F2600000A13061206282700000A280700000A280800000A0C11056F2800000A130711072DD100DE0D11052C0811056F1100000A00DC00DE0D11042C0811046F1100000A00DC027B030000042D19027B0400000472EA010070282900000A2D0772EA0100702B0572200600700D722C0600701A8D05000001251609A2251706A2251808A22519027B04000004A2282A00000A07730C00000A13080072EA010070130911086F2500000A130A002B1A1109110A166F2600000A13061206282700000A280800000A1309110A6F2800000A130B110B2DD9110972EA010070280600000A130C110C2C7E00732B00000A130D110D72A8060070110972B4060070282C00000A6F2D00000A00110D72C20600706F2E00000A130E00110E6F2F00000A130F2B21110F6F3000000A74150000011310027B0500000411106F3100000A6F3200000A00110F6F3300000A2DD6DE16110F7516000001131111112C0811116F1100000A00DC0000DE0D110A2C08110A6F1100000A00DC00DE0D11082C0811086F1100000A00DC00DE0B072C07076F1100000A00DC2A000000419400000200000055000000350000008A0000000D00000000000000020000004B0000004F0000009A0000000D0000000000000002000000810100002E000000AF0100001600000000000000020000000C010000BD000000C90100000D0000000000000002000000FB000000DE000000D90100000D00000000000000020000001A000000CF010000E90100000B0000000000000042534A4201000100000000000C00000076342E302E33303331390000000005006C000000C0030000237E00002C0400006005000023537472696E6773000000008C090000D80600002355530064100000100000002347554944000000741000007C01000023426C6F620000000000000002000001571D0208090A000000FA01330016000001000000240000000300000005000000040000000600000033000000050000000500000002000000020000000100000004000000010000000100000000000302010000000000060079017F03060099017F0306004F016C030F009F03000006005D043E020A00630131030A00E3005C000A00680031030A00C50031030A00BC027E040A00BA007E040A0022037E04060034017F030E003A00B8040A001A055C000A00F8027E040A00C401CA031200A00415021200FA04150206004C031C041200DB001502060005013E020600EB013E020A00AF02CA020A00B000CA020A001403CA0206002F04F003060094043E0206004A003E020600FA01F00306006B04F00306002C007D000A0022015C000A000F0531030A001A0131030A00EB02CA02000000005300000000000100010001001000DF03000015000100010003011000010000001500010003000600CE0127010600100427010600ED002A0106004502270106003F042D015020000000009600BA033401010048220000000086186603060006004822000000008618660306000600542200000000830016003D01060010100100450210100200550210100300660210100400ED00101005009302000001003105090066030100110066030600190066030A00310066030600690066030600B90051052900B90056042F00B9004F043500390066030600510066033B00C100AA020600590066034000C900DD0247002900DF014B00610066034F00D10010025500B1002C0106000C0066030600390064046100D90066030600E100D6046700D90078020100140066037200F100F2017800410035059200410066039600490066039F0011011101A6001901E904AC000C003D05B2004900E801B80019012205AC001901A100060029006603060079003502DE00B900D300E30059000603E9008100C101EE008900B7014B0021019800F400B90045052900B9005604F800910066030600B9004F04FF00910020023B00A900AE030601990058030C01A100AC044700A90028024B000C009D001101A1000605F4000E00050000000E00090000000E000D0000000200110020010800150022012000230074012E000B0043012E0013004C012E001B006B0163002B0074011000BE005B006B0004800000000000000000000000000000000007040000040000000000000000000000170174000000000004000000000000000000000017015C000000000004000000000000000000000017013E020000000004000000000000000000000017011502000000000300020031008D000000003C3E635F5F446973706C6179436C617373305F30003C536561726368416C6C5461626C65733E625F5F300049456E756D657261626C65603100436F6E63757272656E74426167603100416374696F6E6031003C4D6F64756C653E0053797374656D2E446174610053716C4D65746144617461006D73636F726C69620053797374656D2E436F6C6C656374696F6E732E47656E657269630052656164004164640053656E64526573756C7473456E64004462436F6D6D616E640053716C436F6D6D616E640053716C446174615265636F7264005265706C61636500586D6C4E6F646500446174615461626C65006765744F6E6C794669727374526F775065725461626C650049446973706F7361626C65006765745F506970650053716C506970650053716C44625479706500446973706F736500436F6D70696C657247656E6572617465644174747269627574650044656275676761626C654174747269627574650053716C50726F63656475726541747472696275746500436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465006765745F56616C75650047657453716C537472696E6700636F6E6E656374696F6E537472696E6700546F537472696E6700536574537472696E6700466F724561636800506172616C6C656C0053716C5574696C732E646C6C0046696C6C0053797374656D2E586D6C004C6F6164586D6C006765745F4F75746572586D6C006765745F4974656D0053797374656D0076616C75655365617263685465726D007461626C65735365617263685465726D00636F6C756D6E735365617263685465726D007365745F4D61784465677265654F66506172616C6C656C69736D006D61784465677265654F66506172616C6C656C69736D004F70656E004462436F6E6E656374696F6E0053716C436F6E6E656374696F6E0053797374656D2E446174612E436F6D6D6F6E00457865637574655363616C6172004462446174615265616465720053716C44617461526561646572004578656375746552656164657200446244617461416461707465720053716C4461746141646170746572004D6963726F736F66742E53716C5365727665722E5365727665720049456E756D657261746F7200476574456E756D657261746F72002E63746F720053797374656D2E446961676E6F73746963730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300446562756767696E674D6F6465730053656C6563744E6F64657300536561726368416C6C5461626C65730053797374656D2E446174612E53716C54797065730053746F72656450726F636564757265730053797374656D2E546872656164696E672E5461736B730053716C5574696C730071476574436F6C756D6E730053797374656D2E436F6C6C656374696F6E7300506172616C6C656C4F7074696F6E73007375625175657279526573756C747300436F6E63617400466F726D6174004F626A6563740053656C65637400506172616C6C656C4C6F6F70526573756C740053797374656D2E446174612E53716C436C69656E7400456E7669726F6E6D656E7400586D6C446F63756D656E74006765745F43757272656E740053797374656D2E436F6C6C656374696F6E732E436F6E63757272656E74006765745F50726F636573736F72436F756E740053656E64526573756C7473537461727400586D6C4E6F64654C697374004D6F76654E6578740053716C436F6E746578740044617461526F770053656E64526573756C7473526F7700726F77006765745F4D617800546F4172726179006F705F457175616C697479006F705F496E657175616C69747900000081E7530045004C004500430054002000510055004F00540045004E0041004D00450028005400410042004C0045005F0053004300480045004D004100290020002B00200027002E00270020002B002000510055004F00540045004E0041004D00450028005400410042004C0045005F004E0041004D004500290020004100530020005400610062006C0065004E0061006D0065002000460052004F004D00200049004E0046004F0052004D004100540049004F004E005F0053004300480045004D0041002E005400410042004C004500530020005700480045005200450020005400410042004C0045005F00540059005000450020003D0020002700420041005300450020005400410042004C004500270020002000200041004E00440020004F0042004A00450043005400500052004F005000450052005400590028004F0042004A004500430054005F00490044002800510055004F00540045004E0041004D00450028005400410042004C0045005F0053004300480045004D004100290020002B00200027002E00270020002B002000510055004F00540045004E0041004D00450028005400410042004C0045005F004E0041004D004500290029002C0020002700490073004D00530053006800690070007000650064002700290020003D002000300020000101005541004E00440020005400410042004C0045005F004E0041004D00450020002B0020005400410042004C0045005F0053004300480045004D00410020004C0049004B0045002000270025007B0030007D002500270001821B530045004C004500430054002000510055004F00540045004E0041004D004500280043004F004C0055004D004E005F004E0041004D0045002900200041005300200043006F006C004E0061006D0065002000460052004F004D00200049004E0046004F0052004D004100540049004F004E005F0053004300480045004D0041002E0043004F004C0055004D004E00530020005700480045005200450020005400410042004C0045005F0053004300480045004D00410020003D002000500041005200530045004E0041004D004500280040005400610062006C0065004E0061006D0065002C0020003200290020002000200041004E00440020005400410042004C0045005F004E0041004D00450020003D002000500041005200530045004E0041004D004500280040005400610062006C0065004E0061006D0065002C0020003100290020002000200041004E004400200044004100540041005F00540059005000450020004E004F005400200049004E00200028002700620069006E0061007200790027002C0020002700760061007200620069006E0061007200790027002C002000270062006900740027002C0020002700740069006D0065007300740061006D00700027002C002000270069006D0061006700650027002C0020002700730071006C005F00760061007200690061006E00740027002C002000270068006900650072006100720063006800790069006400270029002000013941004E004400200043004F004C0055004D004E005F004E0041004D00450020004C0049004B0045002000270025007B0030007D00250027000180CB530045004C00450043005400200027005300650072007600650072003D00270020002B002000400040005300450052005600450052004E0041004D00450020002B00200027003B00440061007400610062006100730065003D00270020002B002000440042005F004E0041004D0045002800290020002B00200027003B0054007200750073007400650064005F0043006F006E006E0065006300740069006F006E003D0054007200750065003B0045006E006C006900730074003D00460061006C00730065003B002700012F63006F006E007400650078007400200063006F006E006E0065006300740069006F006E003D007400720075006500001146006F0075006E00640052006F007700001540005400610062006C0065004E0061006D006500000B27007B0030007D0027000155490053004E0055004C004C00280043004F004E00560045005200540028004E00560041005200430048004100520028004D004100580029002C0020007B0030007D0029002C00200027002700290020002B002000010B54004F00500020003100007B530045004C0045004300540020007B0030007D0020002A002000460052004F004D0020007B0031007D0020005700480045005200450020007B0032007D0020002700270020004C0049004B0045002000270025007B0033007D0025002700200046004F005200200058004D004C0020004100550054004F003B00010B3C0064006F0063003E00000D3C002F0064006F0063003E00001328002F002F0064006F0063002F002A002900000000C5B2107797B6F941A00840E5AF8C5F010004200101080320000105200101111118070E120C0E0E121D1221122502021229122D12311D0E080E050002020E0E0500020E0E1C0500020E0E0E042001010E062002010E12290320001C0320000E05200101122D05200108121D05151239010E0520001D123D030000080615127501123D052002011C1814100103117D15128081011E00126D151275011E00040A01123D0300000A082003010E1180850A062001011D122105000012808D0520010112250520001D130005200201080E1F07120E12290E0E122D1241114502122D0E124102021249124D1251125512590420011C080520020E0E0E0420001241052001114508032000020600020E0E1D1C0600030E0E0E0E052001124D0E042000125105200101130008B77A5C561934E0890100040000000002060E0206020606151239010E080005010E0E0E020805200101123D0801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F777301080100070100000000040100000000000000000000C245C85900000000020000001C010000F8360000F81800005253445320B2EA7E751EB04BB35445046FF020D301000000433A5C55736572735C4875676F5C536F757263655C5265706F735C4461746162617365315C4461746162617365315C6F626A5C44656275675C53716C5574696C732E70646200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003C38000000000000000000005638000000200000000000000000000000000000000000000000000048380000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000004C02000000000000000000004C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004AC010000010053007400720069006E006700460069006C00650049006E0066006F0000008801000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E00300000003A000D00010049006E007400650072006E0061006C004E0061006D0065000000530071006C005500740069006C0073002E0064006C006C00000000002800020001004C006500670061006C0043006F00700079007200690067006800740000002000000042000D0001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530071006C005500740069006C0073002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E0030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000683800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
194 WITH PERMISSION_SET = UNSAFE;
195GO
196
197PRINT N'Adding CLR assembly debug information...';
198GO
199
200ALTER ASSEMBLY [SqlUtils]
201 DROP FILE ALL
202 ADD FILE FROM 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000020000001B0000008C0000000000000019000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C0FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF380000FCFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA3101380000000010000000100000000000000F00FFFF04000000FFFF03000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA3101380000000010000000100000000000001000FFFF04000000FFFF0300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E3101C245C8590100000020B2EA7E751EB04BB35445046FF020D300000000000000000100000001000000000000000000000000000000DC51330100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BDEC1618FF5EAA104D87F76F4963833460140000000000000067BC13C6612382FD1BEF863517832BA08BC6D2C20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B703000000000000B7030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF010000008600000000433A5C55736572735C4875676F5C536F757263655C5265706F735C4461746162617365315C4461746162617365315C536561726368416C6C5461626C65732E63730000633A5C75736572735C6875676F5C736F757263655C7265706F735C6461746162617365315C6461746162617365315C736561726368616C6C7461626C65732E6373000400000043000000000000000100000044000000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001BE2300180000000BB7E8E7D9035D301010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000200000001000000010000000000000044000000280000001BE23001476939CA5C000000010000004300000044000000650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000003A002A11000000000C03000000000000C2010000000000000000000001000006000000000100000000536561726368416C6C5461626C657300000000160003110400000098020000C201000000000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E740000220024115553797374656D2E436F6C6C656374696F6E732E436F6E63757272656E7400001A0024115553797374656D2E546872656164696E672E5461736B73000E0024115553797374656D2E586D6C001E002411554D6963726F736F66742E53716C5365727665722E5365727665720022002011000000000100001100000000000000004353243C3E385F5F6C6F63616C7330001E00201101000000010000110000000000000000714765745461626C657300001E0020110200000001000011000000000000000071476574436F6E6E537472001E0020110300000001000011000000000000000064745461626C6573000000001A002011040000000100001100000000000000007265636D6574610016002011050000000100001100000000000000007265630016000311400000005C020000790000008D000000010000001A00201108000000010000110000000000000000636F6E6E0000000016000311BC010000580200003C000000BA000000010000001600201109000000010000110000000000000000636D640016000311F00100005402000021000000C5000000010000001A0020110A00000001000011000000000000000061646170746572000200060002000600020006001600031140000000940200002100000087010000010000001A0020110D000000010000110000000000000000717265730000000002000600020006006E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004030000040000000C0000000100070004060000300000001F0101100184060184BB018ED8018F3102817A0283990184EB0185C1018614078F8E098F8E018F8E0407000110000000010101018814020002000600F2000000400200000000000001000100C2010000000000002E0000003402000000000000EEEFFE80140000000D000080150000000E0000831B0000001300008028000000EEEFFE802C000000130000803E00000015000084490000001B00008056000000EEEFFE805A0000001B000080760000001D0000807C0000001F00008087000000210000808D0000002200008099000000230000809A00000024000080A200000026000080BA00000028000080C400000029000080C50000002A000080CE0000002B000080D9000000EEEFFE80E5000000EEEFFE80E60000002C000080E9000000EEEFFE80F5000000EEEFFE80F60000002D000080F9000000EEEFFE8005010000EEEFFE80060100002F00008011010000310000A8420100005B000080550100005C000080670100005E000080740100005F000080750100005F00008085010000EEEFFE80870100005F0000808E010000600000808F010000610000809A01000062000080A701000063000080A8010000EEEFFE80AE0100005F000080B601000064000080C101000065000080000000000500060009008800090024000000000025007100090089000900250000000000260066000900840009002300090028001000470009000A000D0019000D005F0014003E000D000E0018003D0015002C0000000000000000000D000E00000000000000000009000A00000000000000000009003B00090010000900580009002E0009002F00090010001E0037000000000012001A0009000A000D0024000D00310009000A00000000001B001D0009002A0005000600F40000000800000001000000000000000800000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000003E002A11000000001803000000000000F5010000000000000000000004000006C201000001000000003C536561726368416C6C5461626C65733E625F5F3000001600031104000000A8020000F5010000C2010000010000001E002011000000000200001100000000000000007461626C654E616D650000001600031144000000A4020000E6010000D0010000010000001A00201101000000020000110000000000000000636F6E6E00000000160003117C000000A0020000CD010000DC010000010000001E002011020000000200001100000000000000007768657265436C61757365001A0020110300000002000011000000000000000071546F704F6E650016000311B00000006C0100007F000000EA010000010000001600201104000000020000110000000000000000636D64001600031104010000680100004B0000000E020000010000001A002011050000000200001100000000000000007265616465720000020006000200060016000311B00000009C0200001801000090020000010000001600201108000000020000110000000000000000636D6400160003117001000098020000DC000000BD020000010000001A00201109000000020000110000000000000000636D64526573000016000311A001000094020000D3000000C5020000010000001A0020110A000000020000110000000000000000726561646572000016000311D4010000900200007E0000000A030000010000001A0020110D000000020000110000000000000000786D6C646F6300001A0020110E0000000200001100000000000000006E6F64657300000016000311080200008C0200002100000045030000010000001A002011100000000200001100000000000000006E6F64650000000002000600020006000200060002000600020006000200060002000600020006006A000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040100000C00000001000006040600023C00000001882B0188680188E4018AD70189160189A3000289F9018B44018BFD018C2E028C84028CE1018D37018DC6068E10018E1000000002000600F2000000AC020000C201000001000100F50100000000000037000000A0020000000000003600008001000000370000800E000000390000801A0000003A0000801B0000003B000080220000003D000080280000003E0000804B0000003F0000804C00000040000080550000004100008056000000EEEFFE8058000000430000807A0000004200008083000000EEEFFE8087000000440000808A000000EEEFFE8096000000EEEFFE8097000000450000809A000000EEEFFE80A6000000EEEFFE80A700000047000080CE00000048000080FB00000049000080FC0000004A000080030100004B0000800C0100004C0000800D010000EEEFFE800F0100004D000080290100004D00008032010000EEEFFE80360100004F00008044010000EEEFFE8048010000500000804901000051000080500100005200008069010000530000807701000054000080780100005400008081010000EEEFFE8083010000540000809101000054000080A401000054000080AF010000EEEFFE80C4010000EEEFFE80C501000055000080C601000056000080C9010000EEEFFE80D5010000EEEFFE80D601000057000080D9010000EEEFFE80E5010000EEEFFE80E601000058000080E9010000EEEFFE80F3010000EEEFFE80F4010000590000800D000E001100330018004600110012001500210015002A001C007000150016002000400019001A000000000021007A001D0032000000000019001A000000000000000000150016000000000000000000150065001C00A30015001600190029002000400019001A000000000033005A001D003200000000001D002E00000000001D001E002100400021004D0021004D00210028003A003F00000000002A003600410064003700390000000000000000001D001E0019001A0000000000000000001500160000000000000000001100120000000000000000000D000E00F400000008000000010000000000000008000000380000005C0000000000000000000000000000000000000000000000FFFFFFFF1A092FF12000000014020000210000000100000039000000010000005D000000010000000100000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C00000018000000240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E00251100000000040000000100536561726368416C6C5461626C657300000016002911000000000400000001003036303030303031000022002511000000000400000002003C536561726368416C6C5461626C65733E625F5F300016002911000000000400000002003036303030303034000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E3101C245C8590100000020B2EA7E751EB04BB35445046FF020D36F0000002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F633A5C75736572735C6875676F5C736F757263655C7265706F735C6461746162617365315C6461746162617365315C736561726368616C6C7461626C65732E6373000400000006000000010000003A0000000000000011000000070000000A000000060000000000000005000000220000000800000000000000DC513301000100DA2700000000000000000000000053746F72656450726F636564757265732E3C3E635F5F446973706C6179436C617373305F30004435453334374634000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF77093101010000000C000B8E0D00ED620E000000CC0000003C0000002C00000058000000000000000000000016000000190000000000EEC00000000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000A001003000000000000580200000100DA2700000000000000000000000053746F72656450726F6365647572657300434441353133364600000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000B001C03000000000000C40200000100DA2700000000000000000000000053746F72656450726F636564757265732E3C3E635F5F446973706C6179436C617373305F3000443545333437463400002DBA2EF10100000000000000C20100000000000000000000000000000000000001000000C2010000F501000000000000010000000000000000000000020002000D01000000000100FFFFFFFF00000000B70300000802000000000000FFFFFFFF00000000FFFFFFFF0200020000000100010001000000000000000000433A5C55736572735C4875676F5C536F757263655C5265706F735C4461746162617365315C4461746162617365315C536561726368416C6C5461626C65732E6373000000FEEFFEEF010000000100000000010000000000000000000000FFFFFFFFFFFFFFFFFFFF0900FFFFFFFFFFFFFFFFFFFF00000000000F00000020000000CB00000038000000FB0100003800000000000000AA000000800000005C0000002800000074050000EC050000440200002C0000007400000003000000160000000600000017000000070000000A0000000B00000008000000090000000C0000000D0000000E0000000F00000010000000110000001200000013000000150000001400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 AS N'SqlUtils.pdb';
203GO
204
205PRINT N'Adding CLR stored procedure [dbo].[SearchAllTables]...';
206GO
207
208CREATE PROCEDURE [dbo].[SearchAllTables] @valueSearchTerm NVARCHAR (250) NULL = '',
209 @tablesSearchTerm NVARCHAR (250) NULL = '',
210 @columnsSearchTerm NVARCHAR (250) NULL = '',
211 @getOnlyFirstRowPerTable BIT NULL = 0,
212 @maxDegreeOfParallelism INT NULL = 0
213AS EXTERNAL NAME [SqlUtils].[StoredProcedures].[SearchAllTables]
214GO
215
216PRINT N'Installation completed.';
217GO