· 8 years ago · Sep 25, 2017, 12:38 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 = "",
85 string tablesSearchTerm = "",
86 string columnsSearchTerm = "",
87 bool getOnlyFirstRowPerTable = false,
88 int maxDegreeOfParallelism = 0)
89 {
90 var qGetTables = @"SELECT QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) AS TableName "
91 + @"FROM INFORMATION_SCHEMA.TABLES "
92 + @"WHERE TABLE_TYPE = 'BASE TABLE' "
93 + @" AND OBJECTPROPERTY(OBJECT_ID(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)), 'IsMSShipped') = 0 ";
94
95 if (tablesSearchTerm != "") qGetTables += $@"AND TABLE_NAME + TABLE_SCHEMA LIKE '%{tablesSearchTerm}%'";
96
97 var qGetColumns = @"SELECT QUOTENAME(COLUMN_NAME) AS ColName "
98 + @"FROM INFORMATION_SCHEMA.COLUMNS "
99 + @"WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2) "
100 + @" AND TABLE_NAME = PARSENAME(@TableName, 1) "
101 + @" AND DATA_TYPE NOT IN ('binary', 'varbinary', 'bit', 'timestamp', 'image', 'sql_variant', 'hierarchyid') ";
102
103 if (columnsSearchTerm != "") qGetColumns += $@"AND COLUMN_NAME LIKE '%{columnsSearchTerm}%'";
104
105 var qGetConnStr = @"SELECT 'Server=' + @@SERVERNAME + ';Database=' + DB_NAME() + ';Trusted_Connection=True;Enlist=False;'";
106
107 var qTopOne = (getOnlyFirstRowPerTable || valueSearchTerm == "") ? "TOP 1" : "";
108
109 var connectionString = "";
110
111 var dtTables = new DataTable();
112 using (var conn = new SqlConnection("context connection=true"))
113 {
114 conn.Open();
115
116 connectionString = (new SqlCommand(qGetConnStr, conn)).ExecuteScalar().ToString();
117
118 using (var cmd = new SqlCommand(qGetTables, conn))
119 {
120 using (var adapter = new SqlDataAdapter(cmd))
121 adapter.Fill(dtTables);
122 }
123 }
124
125 var subQueryResults = new ConcurrentBag<string>();
126
127 Parallel.ForEach(
128 dtTables.Select(),
129 new ParallelOptions() { MaxDegreeOfParallelism = (maxDegreeOfParallelism == 0) ? Environment.ProcessorCount
130 : maxDegreeOfParallelism },
131 row =>
132 {
133 var tableName = row[0].ToString();
134
135 using (var conn = new SqlConnection(connectionString))
136 {
137 conn.Open();
138
139 var whereClause = "";
140 using (var cmd = new SqlCommand(qGetColumns.Replace("@TableName", $@"'{tableName}'"), conn))
141 {
142 using (var reader = cmd.ExecuteReader())
143 {
144 while (reader.Read())
145 whereClause += $@"ISNULL(CONVERT(NVARCHAR(MAX), {reader.GetSqlString(0).Value}), '') + ";
146 }
147 }
148
149 using (var cmd = new SqlCommand($@"SELECT {qTopOne} * FROM {tableName} WHERE {whereClause} '' LIKE '%{valueSearchTerm}%' FOR XML AUTO;", conn))
150 {
151 var cmdRes = "";
152 using (var reader = cmd.ExecuteReader())
153 {
154 while (reader.Read()) cmdRes += reader.GetSqlString(0).Value;
155
156 if (cmdRes != "")
157 {
158 var xmldoc = new XmlDocument();
159 xmldoc.LoadXml("<doc>" + cmdRes + "</doc>");
160 var nodes = xmldoc.SelectNodes("(//doc/*)");
161 foreach (XmlNode node in nodes) subQueryResults.Add(node.OuterXml);
162 }
163 }
164 }
165 }
166 });
167
168 var recmeta = new SqlMetaData("FoundRow", SqlDbType.NVarChar, SqlMetaData.Max);
169 var rec = new SqlDataRecord(recmeta);
170
171 SqlContext.Pipe.SendResultsStart(rec);
172 foreach (var qres in subQueryResults.ToArray())
173 {
174 rec.SetString(0, qres);
175 SqlContext.Pipe.SendResultsRow(rec);
176 }
177 SqlContext.Pipe.SendResultsEnd();
178 }
179 }
180*/*/
181
182SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
183SET NUMERIC_ROUNDABORT OFF;
184GO
185
186PRINT N'Removing previous versions...';
187GO
188
189DROP PROCEDURE [dbo].[SearchAllTables]
190DROP ASSEMBLY [SqlUtils]
191GO
192
193PRINT N'Adding CLR assembly [SqlUtils]...';
194GO
195
196CREATE ASSEMBLY [SqlUtils]
197 AUTHORIZATION [dbo]
198 FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300364FC8590000000000000000E00022200B013000001A0000000600000000000062380000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000103800004F00000000400000A802000000000000000000000000000000000000006000000C000000D83600001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000006818000000200000001A000000020000000000000000000000000000200000602E72737263000000A80200000040000000040000001C0000000000000000000000000000400000402E72656C6F6300000C000000006000000002000000200000000000000000000000000000400000420000000000000000000000000000000044380000000000004800000002000500E4240000F411000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001B300400E20100000100001173030000060A06027D040000040072010000700B0372EA010070280600000A130611062C120772EC01007003280700000A280800000A0B0672420200707D020000040472EA010070280600000A130711072C1C06067B02000004725F04007004280700000A280800000A7D0200000472990400700C06052D19067B0400000472EA010070280900000A2D0772EA0100702B0572660500707D030000040672EA0100707D01000004730A00000A0D7272050070730B00000A13080011086F0C00000A0006081108730D00000A6F0E00000A6F0F00000A7D01000004071108730D00000A1309001109731000000A130A110A096F1100000A26DE0D110A2C08110A6F1200000A00DC00DE0D11092C0811096F1200000A00DC00DE0D11082C0811086F1200000A00DC06731300000A7D05000004096F1400000A731500000A250E042C040E042B05281600000A6F1700000A0006FE0604000006731800000A280100002B2672A20500701F0C281A00000A731B00000A1304178D0800000125161104A2731C00000A1305281D00000A11056F1E00000A0000067B050000046F1F00000A130B16130C2B27110B110C9A130D00110516110D6F2000000A00281D00000A11056F2100000A0000110C1758130C110C110B8E6932D1281D00000A6F2200000A002A0000012800000200EE000BF9000D000000000200E4002509010D000000000200B9006019010D000000002202282300000A002A0000001B300500CF010000020000110003166F2400000A6F0F00000A0A027B01000004730B00000A0B00076F0C00000A0072EA0100700C027B0200000472B405007072CA05007006280700000A6F2500000A07730D00000A0D00096F2600000A1304002B220872D60500701104166F2700000A13051205282800000A280700000A280800000A0C11046F2900000A130611062DD100DE0D11042C0811046F1200000A00DC00DE0B092C07096F1200000A00DC722C0600701A8D050000012516027B03000004A2251706A2251808A22519027B04000004A2282A00000A07730D00000A13070072EA010070130811076F2600000A1309002B1A11081109166F2700000A13051205282800000A280800000A130811096F2900000A130A110A2DD9110872EA010070280600000A130B110B2C7E00732B00000A130C110C72A8060070110872B4060070282C00000A6F2D00000A00110C72C20600706F2E00000A130D00110D6F2F00000A130E2B21110E6F3000000A7415000001130F027B05000004110F6F3100000A6F3200000A00110E6F3300000A2DD6DE16110E7516000001131011102C0811106F1200000A00DC0000DE0D11092C0811096F1200000A00DC00DE0D11072C0811076F1200000A00DC00DE0B072C07076F1200000A00DC2A0041940000020000005300000035000000880000000D00000000000000020000004A0000004E000000980000000B00000000000000020000005B0100002E00000089010000160000000000000002000000E6000000BD000000A30100000D0000000000000002000000D5000000DE000000B30100000D00000000000000020000001A000000A9010000C30100000B0000000000000042534A4201000100000000000C00000076342E302E33303331390000000005006C000000C0030000237E00002C0400006805000023537472696E67730000000094090000D8060000235553006C1000001000000023475549440000007C1000007801000023426C6F620000000000000002000001571D0208090A000000FA01330016000001000000240000000300000005000000040000000600000033000000050000000500000002000000020000000100000004000000010000000100000000000B020100000000000600810187030600A10187030600570174030F00A70300000600650446020A006B0139030A00E3005C000A00680039030A00C50039030A00C40286040A00BA0086040A002A03860406003C0187030E003A00C0040A0022055C000A00000386040A00CC01D2031200A8041D02120002051D020600540324041200DB001D020600050146020600F30146020A00B702D2020A00B000D2020A001C03D20206003704F80306009C04460206004A00460206000202F80306007304F80306002C007D000A002A015C000A00170539030A00220139030A00F302D202000000005300000000000100010001001000E703000015000100010003011000010000001500010003000600D601260106001804260106001101260106004D0226010600470429015020000000009600C2033001010068220000000086186E030600060068220000000086186E03060006007422000000008300160039010600101001004D02101002005D02101003006E0210100400ED00101005009B0200000100390509006E03010011006E03060019006E030A0031006E03060069006E030600B90059052900B9005E042F00B90057043500B9004D05290039006E03060051006E033B00C100B202060059006E034000C900E50247002900E7014B0061006E034F00D10018025500B100340106000C006E03060039006C046100D9006E030600E100DE046700D9008002010014006E037200F100FA01780041003D05920041006E03960049006E039F0011011901A6001901F104AC000C004505B2004900F001B80019012A05AC001901A100060029006E03060079003D02DD00B900D300E20059000E03E8008100C901ED008900BF014B0021019800F300B9005E04F70091006E030600B9005704FE00910028023B00A900B6030501990060030B01A100B4044700A90030024B000C009D001001A1000E05F3000E00050000000E00090000000E000D000000020011001F010800150021012000230070012E000B003F012E00130048012E001B00670163002B0070011000BE005B006B000480000000000000000000000000000000000F040000040000000000000000000000160174000000000004000000000000000000000016015C0000000000040000000000000000000000160146020000000004000000000000000000000016011D02000000000300020033008D000000003C3E635F5F446973706C6179436C617373305F30003C536561726368416C6C5461626C65733E625F5F300049456E756D657261626C65603100436F6E63757272656E74426167603100416374696F6E6031003C4D6F64756C653E0053797374656D2E446174610053716C4D65746144617461006D73636F726C69620053797374656D2E436F6C6C656374696F6E732E47656E657269630052656164004164640053656E64526573756C7473456E64004462436F6D6D616E640053716C436F6D6D616E640053716C446174615265636F7264005265706C61636500586D6C4E6F646500446174615461626C65006765744F6E6C794669727374526F775065725461626C650049446973706F7361626C650071546F704F6E65006765745F506970650053716C506970650053716C44625479706500446973706F736500436F6D70696C657247656E6572617465644174747269627574650044656275676761626C654174747269627574650053716C50726F63656475726541747472696275746500436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465006765745F56616C75650047657453716C537472696E6700636F6E6E656374696F6E537472696E6700546F537472696E6700536574537472696E6700466F724561636800506172616C6C656C0053716C5574696C732E646C6C0046696C6C0053797374656D2E586D6C004C6F6164586D6C006765745F4F75746572586D6C006765745F4974656D0053797374656D0076616C75655365617263685465726D007461626C65735365617263685465726D00636F6C756D6E735365617263685465726D007365745F4D61784465677265654F66506172616C6C656C69736D006D61784465677265654F66506172616C6C656C69736D004F70656E004462436F6E6E656374696F6E0053716C436F6E6E656374696F6E0053797374656D2E446174612E436F6D6D6F6E00457865637574655363616C6172004462446174615265616465720053716C44617461526561646572004578656375746552656164657200446244617461416461707465720053716C4461746141646170746572004D6963726F736F66742E53716C5365727665722E5365727665720049456E756D657261746F7200476574456E756D657261746F72002E63746F720053797374656D2E446961676E6F73746963730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300446562756767696E674D6F6465730053656C6563744E6F64657300536561726368416C6C5461626C65730053797374656D2E446174612E53716C54797065730053746F72656450726F636564757265730053797374656D2E546872656164696E672E5461736B730053716C5574696C730071476574436F6C756D6E730053797374656D2E436F6C6C656374696F6E7300506172616C6C656C4F7074696F6E73007375625175657279526573756C747300436F6E63617400466F726D6174004F626A6563740053656C65637400506172616C6C656C4C6F6F70526573756C740053797374656D2E446174612E53716C436C69656E7400456E7669726F6E6D656E7400586D6C446F63756D656E74006765745F43757272656E740053797374656D2E436F6C6C656374696F6E732E436F6E63757272656E74006765745F50726F636573736F72436F756E740053656E64526573756C7473537461727400586D6C4E6F64654C697374004D6F76654E6578740053716C436F6E746578740044617461526F770053656E64526573756C7473526F7700726F77006765745F4D617800546F4172726179006F705F457175616C697479006F705F496E657175616C69747900000081E7530045004C004500430054002000510055004F00540045004E0041004D00450028005400410042004C0045005F0053004300480045004D004100290020002B00200027002E00270020002B002000510055004F00540045004E0041004D00450028005400410042004C0045005F004E0041004D004500290020004100530020005400610062006C0065004E0061006D0065002000460052004F004D00200049004E0046004F0052004D004100540049004F004E005F0053004300480045004D0041002E005400410042004C004500530020005700480045005200450020005400410042004C0045005F00540059005000450020003D0020002700420041005300450020005400410042004C004500270020002000200041004E00440020004F0042004A00450043005400500052004F005000450052005400590028004F0042004A004500430054005F00490044002800510055004F00540045004E0041004D00450028005400410042004C0045005F0053004300480045004D004100290020002B00200027002E00270020002B002000510055004F00540045004E0041004D00450028005400410042004C0045005F004E0041004D004500290029002C0020002700490073004D00530053006800690070007000650064002700290020003D002000300020000101005541004E00440020005400410042004C0045005F004E0041004D00450020002B0020005400410042004C0045005F0053004300480045004D00410020004C0049004B0045002000270025007B0030007D002500270001821B530045004C004500430054002000510055004F00540045004E0041004D004500280043004F004C0055004D004E005F004E0041004D0045002900200041005300200043006F006C004E0061006D0065002000460052004F004D00200049004E0046004F0052004D004100540049004F004E005F0053004300480045004D0041002E0043004F004C0055004D004E00530020005700480045005200450020005400410042004C0045005F0053004300480045004D00410020003D002000500041005200530045004E0041004D004500280040005400610062006C0065004E0061006D0065002C0020003200290020002000200041004E00440020005400410042004C0045005F004E0041004D00450020003D002000500041005200530045004E0041004D004500280040005400610062006C0065004E0061006D0065002C0020003100290020002000200041004E004400200044004100540041005F00540059005000450020004E004F005400200049004E00200028002700620069006E0061007200790027002C0020002700760061007200620069006E0061007200790027002C002000270062006900740027002C0020002700740069006D0065007300740061006D00700027002C002000270069006D0061006700650027002C0020002700730071006C005F00760061007200690061006E00740027002C002000270068006900650072006100720063006800790069006400270029002000013941004E004400200043004F004C0055004D004E005F004E0041004D00450020004C0049004B0045002000270025007B0030007D00250027000180CB530045004C00450043005400200027005300650072007600650072003D00270020002B002000400040005300450052005600450052004E0041004D00450020002B00200027003B00440061007400610062006100730065003D00270020002B002000440042005F004E0041004D0045002800290020002B00200027003B0054007200750073007400650064005F0043006F006E006E0065006300740069006F006E003D0054007200750065003B0045006E006C006900730074003D00460061006C00730065003B002700010B54004F00500020003100002F63006F006E007400650078007400200063006F006E006E0065006300740069006F006E003D007400720075006500001146006F0075006E00640052006F007700001540005400610062006C0065004E0061006D006500000B27007B0030007D0027000155490053004E0055004C004C00280043004F004E00560045005200540028004E00560041005200430048004100520028004D004100580029002C0020007B0030007D0029002C00200027002700290020002B002000017B530045004C0045004300540020007B0030007D0020002A002000460052004F004D0020007B0031007D0020005700480045005200450020007B0032007D0020002700270020004C0049004B0045002000270025007B0033007D0025002700200046004F005200200058004D004C0020004100550054004F003B00010B3C0064006F0063003E00000D3C002F0064006F0063003E00001328002F002F0064006F0063002F002A002900000000F654FB1BA50E5741A1BBB22CDC2EF9D00004200101080320000105200101111118070E120C0E0E121D1221122502021229122D12311D0E080E050002020E0E0500020E0E1C0500020E0E0E042001010E062002010E12290320001C0320000E05200101122D05200108121D05151239010E0520001D123D030000080615127501123D052002011C1814100103117D15128081011E00126D151275011E00040A01123D0300000A082003010E1180850A062001011D122105000012808D0520010112250520001D130005200201080E1E07110E12290E122D1241114502122D0E124102021249124D1251125512590420011C080520020E0E0E0420001241052001114508032000020600020E0E1D1C0600030E0E0E0E052001124D0E042000125105200101130008B77A5C561934E0890100040000000002060E0606151239010E080005010E0E0E020805200101123D0801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F777301080100070100000000040100000000000000000000364FC85900000000020000001C010000F4360000F4180000525344531CFE15909A794C4B8F0E8852D4A0D40A01000000433A5C55736572735C4875676F5C536F757263655C5265706F735C4461746162617365315C4461746162617365315C6F626A5C44656275675C53716C5574696C732E70646200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003838000000000000000000005238000000200000000000000000000000000000000000000000000044380000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000004C02000000000000000000004C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004AC010000010053007400720069006E006700460069006C00650049006E0066006F0000008801000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E00300000003A000D00010049006E007400650072006E0061006C004E0061006D0065000000530071006C005500740069006C0073002E0064006C006C00000000002800020001004C006500670061006C0043006F00700079007200690067006800740000002000000042000D0001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530071006C005500740069006C0073002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E0030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000643800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
199 WITH PERMISSION_SET = UNSAFE;
200GO
201
202PRINT N'Adding CLR assembly debug information...';
203GO
204
205ALTER ASSEMBLY [SqlUtils]
206 DROP FILE ALL
207 ADD FILE FROM 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000020000001B0000008C0000000000000019000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C0FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF380000FCFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA3101380000000010000000100000000000000F00FFFF04000000FFFF03000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA3101380000000010000000100000000000001000FFFF04000000FFFF0300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E3101364FC859010000001CFE15909A794C4B8F0E8852D4A0D40A00000000000000000100000001000000000000000000000000000000DC51330100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BDEC1618FF5EAA104D87F76F496383346014000000000000009DC4742E93FBA2BA84A54AE2F6A21240A303CD770000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B103000000000000B1030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF010000008600000000433A5C55736572735C4875676F5C536F757263655C5265706F735C4461746162617365315C4461746162617365315C536561726368416C6C5461626C65732E63730000633A5C75736572735C6875676F5C736F757263655C7265706F735C6461746162617365315C6461746162617365315C736561726368616C6C7461626C65732E6373000400000043000000000000000100000044000000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001BE230018000000039AD08209635D301010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000200000001000000010000000000000044000000280000001BE230016AB131F65C000000010000004300000044000000650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000003A002A11000000000C03000000000000E2010000000000000000000001000006000000000100000000536561726368416C6C5461626C657300000000160003110400000098020000E201000000000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E740000220024115553797374656D2E436F6C6C656374696F6E732E436F6E63757272656E7400001A0024115553797374656D2E546872656164696E672E5461736B73000E0024115553797374656D2E586D6C001E002411554D6963726F736F66742E53716C5365727665722E5365727665720022002011000000000100001100000000000000004353243C3E385F5F6C6F63616C7330001E00201101000000010000110000000000000000714765745461626C657300001E0020110200000001000011000000000000000071476574436F6E6E537472001E0020110300000001000011000000000000000064745461626C6573000000001A002011040000000100001100000000000000007265636D6574610016002011050000000100001100000000000000007265630016000311400000005C02000079000000AD000000010000001A00201108000000010000110000000000000000636F6E6E0000000016000311BC010000580200003C000000DA000000010000001600201109000000010000110000000000000000636D640016000311F00100005402000021000000E5000000010000001A0020110A000000010000110000000000000000616461707465720002000600020006000200060016000311400000009402000021000000A7010000010000001A0020110D000000010000110000000000000000717265730000000002000600020006006E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004030000040000000C0000000100070004060000300000001F01011001840601850F018EE8018F4102817A02839901853F018615018668078F9E098F9E018F9E040700011000000001010101888A020002000600F20000004C0200000000000001000100E2010000000000002F0000004002000000000000EEEFFE800D000000110000800E00000012000083140000001700008021000000EEEFFE8025000000170000803700000019000084420000001F0000804F000000EEEFFE80530000001F0000806F0000002100008075000000230000809C00000025000080A700000027000080AD00000028000080B900000029000080BA0000002A000080C20000002C000080DA0000002E000080E40000002F000080E500000030000080EE00000031000080F9000000EEEFFE8005010000EEEFFE80060100003200008009010000EEEFFE8015010000EEEFFE80160100003300008019010000EEEFFE8025010000EEEFFE80260100003500008031010000370000AA62010000630000807501000064000080870100006600008094010000670000809501000067000080A5010000EEEFFE80A701000067000080AE01000068000080AF01000069000080BA0100006A000080C70100006B000080C8010000EEEFFE80CE01000067000080D60100006C000080E10100006D00008000000000050006000900880009002400000000002500710009008900090025000000000026006600090084000900590009002300090028001000470009000A000D0019000D005F0014003E000D000E0018003D0015002C0000000000000000000D000E00000000000000000009000A00000000000000000009003B00090010000900580009002E0009002F00090010001E0037000000000012001A0009000A000D0024000D00310009000A00000000001B001D0009002A0005000600F40000000800000001000000000000000800000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000003E002A1100000000F802000000000000CF010000000000000000000004000006E201000001000000003C536561726368416C6C5461626C65733E625F5F30000016000311040000008C020000CF010000E2010000010000001E002011000000000200001100000000000000007461626C654E616D65000000160003114400000088020000C0010000F0010000010000001A00201101000000020000110000000000000000636F6E6E00000000160003117C00000084020000A7010000FC010000010000001E002011020000000200001100000000000000007768657265436C617573650016000311B0000000500100007B0000000A020000010000001600201103000000020000110000000000000000636D640016000311E80000004C0100004A0000002D020000010000001A002011040000000200001100000000000000007265616465720000020006000200060016000311B0000000800200001D01000085020000010000001600201107000000020000110000000000000000636D640016000311540100007C020000DC000000B7020000010000001A00201108000000020000110000000000000000636D645265730000160003118401000078020000D3000000BF020000010000001A00201109000000020000110000000000000000726561646572000016000311B8010000740200007E00000004030000010000001A0020110C000000020000110000000000000000786D6C646F6300001A0020110D0000000200001100000000000000006E6F64657300000016000311EC01000070020000210000003F030000010000001A0020110F0000000200001100000000000000006E6F646500000000020006000200060002000600020006000200060002000600020006000200060066000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040100000C0000000100000604060001380000000188A10188DE01895A01898C018A1900028A6F018B54018C0D018C3E028C94028CF1018D47018DD6068E20018E20000002000600F2000000A0020000E201000001000100CF010000000000003600000094020000000000003F00008001000000400000800E000000420000801A000000430000801B00000044000080220000004600008028000000470000804A000000480000804B00000049000080530000004A00008054000000EEEFFE80560000004C000080780000004B00008081000000EEEFFE80850000004D00008088000000EEEFFE8094000000EEEFFE80950000004E00008098000000EEEFFE80A2000000EEEFFE80A300000050000080D500000051000080D600000052000080DD00000053000080E600000054000080E7000000EEEFFE80E90000005500008003010000550000800C010000EEEFFE8010010000570000801E010000EEEFFE80220100005800008023010000590000802A0100005A000080430100005B000080510100005C000080520100005C0000805B010000EEEFFE805D0100005C0000806B0100005C0000807E0100005C00008089010000EEEFFE809E010000EEEFFE809F0100005D000080A00100005E000080A3010000EEEFFE80AF010000EEEFFE80B00100005F000080B3010000EEEFFE80BF010000EEEFFE80C001000060000080C3010000EEEFFE80CD010000EEEFFE80CE010000610000800D000E001100330018004600110012001500210015002A001C007000150016002000400019001A000000000021007A001D0032000000000019001A0000000000000000001500160000000000000000001C00A30015001600190029002000400019001A000000000033005A001D003200000000001D002E00000000001D001E002100400021004D0021004D00210028003A003F00000000002A003600410064003700390000000000000000001D001E0019001A0000000000000000001500160000000000000000001100120000000000000000000D000E00F400000008000000010000000000000008000000380000005C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF12000000014020000210000000100000039000000010000005D000000010000000100000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C00000018000000240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E00251100000000040000000100536561726368416C6C5461626C657300000016002911000000000400000001003036303030303031000022002511000000000400000002003C536561726368416C6C5461626C65733E625F5F300016002911000000000400000002003036303030303034000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000012F700000000D1CB12F7FFFFFFFF1A092FF10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000942E3101364FC859010000001CFE15909A794C4B8F0E8852D4A0D40A6F0000002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F633A5C75736572735C6875676F5C736F757263655C7265706F735C6461746162617365315C6461746162617365315C736561726368616C6C7461626C65732E6373000400000006000000010000003A0000000000000011000000070000000A000000060000000000000005000000220000000800000000000000DC513301000100DA2700000000000000000000000053746F72656450726F636564757265732E3C3E635F5F446973706C6179436C617373305F30004435453334374634000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF77093101010000000C000B8E0D00ED620E000000CC0000003C0000002C00000058000000000000000000000016000000190000000000EEC00000000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000A001003000000000000640200000100DA2700000000000000000000000053746F72656450726F6365647572657300434441353133364600000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000B00FC02000000000000B80200000100DA2700000000000000000000000053746F72656450726F636564757265732E3C3E635F5F446973706C6179436C617373305F3000443545333437463400002DBA2EF10100342600000000E20100000000000000003426000000000000000001000000E2010000CF01000000000000010000000000000000000000020002000D01000000000100FFFFFFFF00000000B10300000802000000000000FFFFFFFF00000000FFFFFFFF0200020000000100010001000000000000000000433A5C55736572735C4875676F5C536F757263655C5265706F735C4461746162617365315C4461746162617365315C536561726368416C6C5461626C65732E6373000000FEEFFEEF010000000100000000010000000000000000000000FFFFFFFFFFFFFFFFFFFF0900FFFFFFFFFFFFFFFFFFFF00000000000F00000020000000CB00000038000000FB0100003800000000000000AA000000800000005C0000002800000080050000C0050000440200002C0000007400000003000000160000000600000017000000070000000A0000000B00000008000000090000000C0000000D0000000E0000000F00000010000000110000001200000013000000150000001400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 AS N'SqlUtils.pdb';
208GO
209
210PRINT N'Adding CLR stored procedure [dbo].[SearchAllTables]...';
211GO
212
213CREATE PROCEDURE [dbo].[SearchAllTables] @valueSearchTerm NVARCHAR (250) NULL = '',
214 @tablesSearchTerm NVARCHAR (250) NULL = '',
215 @columnsSearchTerm NVARCHAR (250) NULL = '',
216 @getOnlyFirstRowPerTable BIT NULL = 0,
217 @maxDegreeOfParallelism INT NULL = 0
218AS EXTERNAL NAME [SqlUtils].[StoredProcedures].[SearchAllTables]
219GO
220
221PRINT N'Installation completed.';
222GO