SQL Server & MSBI: Stored procedure to script tables

Both procedures are created in master database as system object so that they can be called from current database context.
There is quite a bit options I created please eyeball them.
The procedure uses READ UNCOMMITTED transaction level, I created it this way since our environment has a lot of DDL activity and every other tool gets lock timeout errors including management studio.
For partitioned tables the script gets the definition from the first partition.
The tables can be filtered by
a-) objectname (schema.tablename) this is default
b-) schema, table (input parameter is a valid like syntax, null means no filter)
c-) a TableList xml input which takes tablename or schemaname either of them can be null which means no filter
There is no cursor or looping, all tables can be scripted within one batch and usually within a second.
The procedure is using a string concat clr function, the code and compiled assembly is below. It assumed the clr aggregate is created in Util database (hardcoded in sp_scriptmain procedure).
When @PrintSQL parameter is set the output sql will be outputted as XML overcome, Management studio lets you print out up to 2GB in grid mode. The procedure can also return the sql statement as an output or can execute the SQL statement.

Enjoy
-- samples
-- script Humanresources.Employee Table
EXEC sp_script 'Humanresources.Employee'
-- script all tables
EXEC sp_script
-- script tables in schema like %dbo%
EXEC sp_script @SchemaName = '%dbo%'
-- script tables like %test% in schema dbo
EXEC sp_script @SchemaName = 'dbo', @TableName = '%test%'
USE MASTER GO IF OBJECT_ID('sp_scriptmain') IS NULL   EXEC('CREATE PROCEDURE sp_scriptmain AS SELECT 1 AS ID') GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:        Gokhan Varol -- Create date: 10/05/2010 -- Description:    1. Generates create and drop scripts for tables and it's constraints -- ============================================= ALTER PROCEDURE sp_scriptmain  @ObjectName SYSNAME = NULL, /*Fully qualified name*/  @SchemaName SYSNAME = NULL, /* NULL for all, supports like */  @TableName SYSNAME = NULL, /* NULL for all, supports like */  @TableList XML = NULL, /* Will overwrite @TableName */  @NewSchemaName SYSNAME = NULL, /* NULL to scripts objects in original schema, any value overwrites */  @NewTableName SYSNAME = NULL, /* This can be used if only one table is scripted, it will change the table name */  @NewDatabaseName SYSNAME = NULL, /* To change the database context */  @NewFileGroup SYSNAME = NULL, /* A new filegroup for all objects created can be given or a full partition schema with column) */  @NewPartition SYSNAME = NULL, /* Full partition clause with the parameter like '[psDatasupplierIdTrans]([DataSupplierId])' */  @NewDataCompression SYSNAME = NULL, /* A blank value will not script datacompression options, any value will create all objects with the new data compression */  @AddNamePrefix SYSNAME = NULL, /* Adds a prefix to table and constraint names being created */  @ReplaceReferenceSchemaFrom SYSNAME = NULL, /* ** For foreign key constrainst you can replace a referenced schema name @ReplaceReferenceSchemaFrom as @ReplaceReferenceSchemaTo */  @ReplaceReferenceSchemaTo SYSNAME = NULL, /* ** Used in conjunction with @ReplaceReferenceSchemaFrom*/  @DropForeignKey BIT = 0,  @DropTable BIT = 0,  @DropDefaultConstraints BIT = 0, /* This will drop default constraints */  @DropIndexes BIT = 0, /* This will drop primary keys, unique keys and indexes */  @DropCheckConstraint BIT = 0,  @CreateTable BIT = 0, /* Table will always be created with it's defaults */  @CreateDefaultConstraints BIT = 0, /* This will create default constraints */  @CreatePrimaryKey BIT = 0,  @CreateUniqueKey BIT = 0,  @CreateIndex BIT = 0,  @CreateForeignKey BIT = 0,  @CreateCheckConstraint BIT = 0,  @IgnoreDisabledForeignKey BIT = 0,  @IgnoreDisabledCheckConstraint BIT = 0,  @UseGOBatchTerminator BIT = 0,  @SQL VARCHAR(MAX) = NULL OUTPUT, /* This will append to the passed value */  @PrintSQL BIT = 0, /* generates a single column, single row xml record */  @ExecuteSQL BIT = 0, /* Executes the generated sql statement */  @UseTransaction BIT = 0 /* SQL script will be executed within a transaction */ AS  SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED /* @TableList XML Format -- SELECT s.name AS schemaname, t.name FROM sys.tables t INNER JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE s.name = 'ttrans' FOR XML RAW('Tables') <Tables schemaname="tTrans" name="Trans" /> <Tables schemaname="tTrans" name="TransAssignment" /> <Tables schemaname="tTrans" name="TransDeed" /> <Tables schemaname="tTrans" name="TransInvoluntaryLien" /> <Tables schemaname="tTrans" name="TransLegal" /> <Tables schemaname="tTrans" name="TransLegalParty" /> <Tables schemaname="tTrans" name="TransLegalPartyName" /> <Tables schemaname="tTrans" name="TransLegalPartyOrigName" /> <Tables schemaname="tTrans" name="TransLegalPartyParsed" /> <Tables schemaname="tTrans" name="TransLien" /> <Tables schemaname="tTrans" name="TransLot" /> <Tables schemaname="tTrans" name="TransPcrFields" /> <Tables schemaname="tTrans" name="TransPreForeclosure" /> <Tables schemaname="tTrans" name="TransPreForeclosureDetail" /> <Tables schemaname="tTrans" name="TransReject" /> <Tables schemaname="tTrans" name="TransRelease" /> <Tables schemaname="tTrans" name="TransSitus" /> <Tables schemaname="tTrans" name="TransText" /> */ IF @DropForeignKey = 0  AND @DropTable = 0  AND @CreateTable = 0  AND @DropIndexes = 0  AND @DropDefaultConstraints = 0  AND @CreateDefaultConstraints = 0  AND @CreatePrimaryKey = 0  AND @CreateUniqueKey = 0  AND @CreateIndex = 0  AND @CreateForeignKey = 0  AND @DropCheckConstraint = 0  AND @CreateCheckConstraint = 0   BEGIN  PRINT '/* ****************** DESCRIPTION OF PARAMETERS ******************     @ObjectName sysname = NULL, -- Fully qualified name     @SchemaName sysname = NULL    -- NULL for all, supports like     @TableName sysname = NULL    -- NULL for all, supports like     @TableList XML = NULL -- <Tables name="Trans" /> <Tables name="TransAssignment" />     @NewSchemaName sysname = NULL    -- NULL to scripts objects in original schema, any value overwrites     @NewTableName sysname = NULL    -- This can be used if only one table is scripted, it will change the table name     @NewDatabaseName sysname = NULL    -- To change the database context     @NewFileGroup sysname = NULL    -- A new filegroup for all objects created can be given or a full partition schema with column)     @NewPartition sysname = NULL    -- Full partition clause with the parameter like ''[psDatasupplierIdTrans]([DataSupplierId])''     @NewDataCompression sysname = NULL    -- A blank value will not script datacompression options, any value will create all objects with the new data compression     @AddNamePrefix sysname = NULL    -- Adds a prefix to table and constraint names being created     @ReplaceReferenceSchemaFrom sysname = NULL    -- ** For foreign key constrainst you can replace a referenced schema name @ReplaceReferenceSchemaFrom as @ReplaceReferenceSchemaTo     @ReplaceReferenceSchemaTo sysname = NULL    -- Used in conjunction with @ReplaceReferenceSchemaFrom     @DropIndexes BIT = 0    -- This will drop primary keys, unique keys and indexes     @DropDefaultConstraints BIT = 0 -- This will drop default constraints     @CreateDefaultConstraints BIT = 0 -- This will create default constraints     @CreateTable BIT = 0    -- Table will always be created with it''s defaults     @SQL VARCHAR(MAX) = NULL OUTPUT    -- This will append to the passed value     @PrintSQL BIT = 0    -- generates a single column, single row xml record     @ExecuteSQL BIT = 0    -- Executes the generated sql statement     @UseTransaction BIT = 0 SQL script will be executed within a transaction  ****************** DESCRIPTION OF PARAMETERS ****************** */  DECLARE @ReturnVal INT EXEC @ReturnVal = sp_scriptmain     @ObjectName = NULL,     @SchemaName = NULL,     @TableName = NULL,     @TableList = NULL,     @NewSchemaName = NULL,     @NewTableName = NULL,     @NewDatabaseName = NULL,     @NewFileGroup = NULL,     @NewPartition = NULL,     @NewDataCompression = NULL,     @AddNamePrefix = NULL,     @ReplaceReferenceSchemaFrom = NULL,     @ReplaceReferenceSchemaTo = NULL,     @DropForeignKey = 0,     @DropTable = 0,     @DropIndexes = 0,     @DropDefaultConstraints = 0,     @DropCheckConstraint = 0,     @CreateTable = 0,     @CreateDefaultConstraints = 0,     @CreatePrimaryKey = 0,     @CreateUniqueKey = 0,     @CreateIndex = 0,     @CreateForeignKey = 0,     @CreateCheckConstraint = 0,     @IgnoreDisabledForeignKey = 0,     @IgnoreDisabledCheckConstraint = 0,     @UseGOBatchTerminator = 0,     @SQL = NULL,     @PrintSQL = 0,     @ExecuteSQL = 0,     @UseTransaction = 0  SELECT @ReturnVal AS ''@ReturnVal'' '  RETURN 2  END DECLARE @BatchTerminator VARCHAR(10) = CASE WHEN @UseGOBatchTerminator = 1 AND @ExecuteSQL = 0 THEN 'GO ' ELSE '' END DECLARE @ObjectIdList TABLE (  TableId INT NOT NULL  PRIMARY KEY CLUSTERED,  object_id INT NOT NULL  UNIQUE NONCLUSTERED,  SchemaName SYSNAME NOT NULL,  TableName SYSNAME NOT NULL,  lock_escalation_desc VARCHAR(100) NOT NULL) ;  IF @TableList IS NOT NULL   BEGIN         DECLARE @TableIncludeList TABLE (SchemaName SYSNAME NULL, TableName SYSNAME NULL)          INSERT @TableIncludeList (SchemaName, TableName)         SELECT DISTINCT                 t.item.value('@schemaname', 'sysname') AS SchemaName, t.item.value('@name', 'sysname') AS TableName         FROM @TableList.nodes('/Tables') AS t (item)                   INSERT @ObjectIdList (TableId, object_id, SchemaName, TableName, lock_escalation_desc)                 SELECT ROW_NUMBER() OVER (ORDER BY sc.name, tb.name) AS TableId, tb.object_id, ISNULL(@NewSchemaName, sc.name) AS SchemaName,                         ISNULL(@AddNamePrefix, '') + ISNULL(@NewTableName, tb.name) AS TableName,                         lock_escalation_desc COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS AS lock_escalation_desc                 FROM sys.schemas AS sc WITH (NOLOCK)                 INNER JOIN sys.tables AS tb WITH (NOLOCK) ON sc.schema_id = tb.schema_id                 WHERE EXISTS ( SELECT *                                  FROM @TableIncludeList tl                                  WHERE (tl.SchemaName IS NULL                                          OR tl.SchemaName = sc.name)                                         AND (tl.TableName IS NULL                                              OR tl.TableName = tb.name) )  END ELSE   IF @ObjectName IS NOT NULL   BEGIN  INSERT @ObjectIdList (TableId, object_id, SchemaName, TableName, lock_escalation_desc)  SELECT 1 AS TableId, tb.object_id, ISNULL(@NewSchemaName, sc.name) AS SchemaName,  ISNULL(@AddNamePrefix, '') + ISNULL(@NewTableName, tb.name) AS TableName,  lock_escalation_desc COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS AS lock_escalation_desc  FROM sys.schemas AS sc WITH (NOLOCK)  INNER JOIN sys.tables AS tb WITH (NOLOCK) ON sc.schema_id = tb.schema_id  WHERE tb.object_id = OBJECT_ID(@ObjectName)  END  ELSE   BEGIN  INSERT @ObjectIdList (TableId, object_id, SchemaName, TableName, lock_escalation_desc)  SELECT ROW_NUMBER() OVER (ORDER BY sc.name, tb.name) AS TableId, tb.object_id, ISNULL(@NewSchemaName, sc.name) AS SchemaName,  ISNULL(@AddNamePrefix, '') + ISNULL(@NewTableName, tb.name) AS TableName,  lock_escalation_desc COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS AS lock_escalation_desc  FROM sys.schemas AS sc WITH (NOLOCK)  INNER JOIN sys.tables AS tb WITH (NOLOCK) ON sc.schema_id = tb.schema_id  WHERE (@SchemaName IS NULL  OR sc.name LIKE @SchemaName)  AND (@TableName IS NULL  OR tb.name LIKE @TableName)  AND tb.is_ms_shipped = 0  END ;  WITH TableInfo  AS (SELECT TOP 99999999  tl.TableId, SchemaName, TableName, tl.lock_escalation_desc,  CASE WHEN @NewPartition <> '' THEN 'ON ' + @NewPartition  WHEN @NewFileGroup = '' THEN ''  ELSE ISNULL('ON [' + @NewFileGroup + ']', CASE ds.type  WHEN 'FG' THEN 'ON [' + ds.name + ']'  WHEN 'PS' THEN 'ON [' + ds.name + ']([' + pc.name + '])'  WHEN 'FD' THEN ''  ELSE ''  END)  END AS FileGroup,  CASE WHEN @NewDataCompression = '' THEN ''  ELSE ISNULL('WITH (DATA_COMPRESSION = ' + @NewDataCompression + ')', CASE pr.data_compression  WHEN 0 THEN ''  WHEN 1 THEN ' WITH (DATA_COMPRESSION = ROW)'  WHEN 2 THEN ' WITH (DATA_COMPRESSION = PAGE)'  END)  END AS DataCompression  FROM @ObjectIdList AS tl  INNER JOIN sys.indexes AS ix WITH (NOLOCK) ON tl.object_id = ix.object_id  INNER JOIN sys.data_spaces AS ds WITH (NOLOCK) ON ds.data_space_id = ix.data_space_id  INNER JOIN sys.partitions AS pr WITH (NOLOCK) ON pr.object_id = ix.object_id  AND pr.index_id = ix.index_id  LEFT OUTER JOIN sys.index_columns AS ic WITH (NOLOCK) ON ic.object_id = ix.object_id  AND ic.index_id = ix.index_id  AND ic.partition_ordinal = 1  LEFT OUTER JOIN sys.columns AS pc WITH (NOLOCK) ON pc.object_id = ic.object_id  AND pc.column_id = ic.column_id  WHERE ix.index_id <= 1  AND pr.partition_number = 1  AND @CreateTable = 1  ORDER BY tl.TableId),  TableColumns  AS (SELECT TOP 99999999  tl.TableId, co.name AS ColumnName,  CASE WHEN ts.name IN ('char', 'varchar')  THEN ts.name + '(' + CASE WHEN co.max_length = -1 THEN 'MAX'  ELSE CAST (co.max_length AS VARCHAR)  END + ')' + CASE WHEN co.collation_name <> db.collation_name THEN ' COLLATE ' + co.collation_name  ELSE ''  END  WHEN ts.name IN ('nchar', 'nvarchar')  THEN ts.name + '(' + CASE WHEN co.max_length = -1 THEN 'MAX'  ELSE CAST (co.max_length / 2 AS VARCHAR)  END + ')' + CASE WHEN co.collation_name <> db.collation_name THEN ' COLLATE ' + co.collation_name  ELSE ''  END  WHEN ts.name IN ('binary', 'varbinary') THEN ts.name + '(' + CASE WHEN co.max_length = -1 THEN 'MAX'  ELSE CAST (co.max_length AS VARCHAR)  END + ')'  WHEN ts.name IN ('bigint', 'int', 'smallint', 'tinyint') THEN ts.name  WHEN ts.name IN ('datetime2', 'time', 'datetimeoffset') THEN ts.name + '(' + CAST (co.scale AS VARCHAR) + ')'  WHEN ts.name IN ('numeric', 'decimal')  THEN ts.name + '(' + CAST (co.precision AS VARCHAR) + ', ' + CAST (co.scale AS VARCHAR) + ')'  ELSE ts.name  END + CASE WHEN co.is_identity = 1 THEN ' IDENTITY'  ELSE ''  END + +' ' + CASE WHEN co.is_nullable = 1 THEN 'NULL'  ELSE 'NOT NULL'  END + CASE WHEN @CreateDefaultConstraints = 1  THEN CASE dc.is_system_named  WHEN 1 THEN ' DEFAULT ' + dc.definition  WHEN 0  THEN ' CONSTRAINT [' + ISNULL(@AddNamePrefix, '') + dc.name + '] DEFAULT ' + dc.definition  ELSE ''  END  ELSE ''  END AS ColumnDef  FROM @ObjectIdList AS tl  INNER JOIN sys.columns AS co WITH (NOLOCK) ON co.object_id = tl.object_id  INNER JOIN sys.types AS ts WITH (NOLOCK) ON ts.user_type_id = co.user_type_id  INNER JOIN sys.databases AS db WITH (NOLOCK) ON db.database_id = DB_ID()  LEFT OUTER JOIN sys.default_constraints AS dc WITH (NOLOCK) ON dc.parent_object_id = tl.object_id  AND dc.parent_column_id = co.column_id  WHERE @CreateTable = 1  ORDER BY tl.TableId, co.Column_id),  ForeignKeyNames  AS (SELECT TOP 99999999  tl.TableId, ISNULL(@AddNamePrefix, '') + fk.name AS KeyName  FROM @ObjectIdList AS tl  INNER JOIN sys.foreign_keys AS fk WITH (NOLOCK) ON fk.parent_object_id = tl.object_id  WHERE @DropForeignKey = 1  AND ((@IgnoreDisabledForeignKey = 1  AND fk.is_disabled = 0)  OR ISNULL(@IgnoreDisabledForeignKey, 0) = 0)  ORDER BY tl.TableId, fk.name),  DefaultConstraintNames  AS (SELECT TOP 99999999  tl.TableId, ISNULL(@AddNamePrefix, '') + dc.name AS ConstraintName, c.name AS ColumnName, definition  FROM sys.default_constraints AS dc WITH (NOLOCK)  INNER JOIN @ObjectIdList AS tl ON tl.object_id = dc.parent_object_id  INNER JOIN sys.columns AS c WITH (NOLOCK) ON c.object_id = dc.parent_object_id  AND dc.parent_column_id = c.column_id  WHERE (@DropDefaultConstraints = 1  OR (@CreateTable = 0  AND @CreateDefaultConstraints = 1))  ORDER BY tl.TableId, dc.name),  ForeignKeyColumns  AS (SELECT TOP 99999999  tl.TableId, ISNULL(@AddNamePrefix, '') + fk.name AS KeyName, pc.name AS pColName,  CASE WHEN rs.name = @ReplaceReferenceSchemaFrom  AND @ReplaceReferenceSchemaTo <> '' THEN @ReplaceReferenceSchemaTo  ELSE rs.name  END AS rSchemaName, rt.name AS rTableName, rc.name AS rColName, fk.delete_referential_action,  fk.delete_referential_action_desc COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS AS delete_referential_action_desc,  fk.update_referential_action,  fk.update_referential_action_desc COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS AS update_referential_action_desc, fk.is_not_for_replication,  fk.is_disabled  FROM @ObjectIdList AS tl  INNER JOIN sys.foreign_keys AS fk WITH (NOLOCK) ON fk.parent_object_id = tl.object_id  INNER JOIN sys.tables AS rt WITH (NOLOCK) ON rt.object_id = fk.referenced_object_id  INNER JOIN sys.schemas AS rs WITH (NOLOCK) ON rs.schema_id = rt.schema_id  INNER JOIN sys.foreign_key_columns AS pfkc WITH (NOLOCK) ON pfkc.constraint_object_id = fk.object_id  INNER JOIN sys.columns AS pc WITH (NOLOCK) ON pc.object_id = pfkc.parent_object_id  AND pc.column_id = pfkc.parent_column_id  INNER JOIN sys.columns AS rc WITH (NOLOCK) ON rc.object_id = pfkc.referenced_object_id  AND rc.column_id = pfkc.referenced_column_id  WHERE @CreateForeignKey = 1  AND ((@IgnoreDisabledForeignKey = 1  AND fk.is_disabled = 0)  OR ISNULL(@IgnoreDisabledForeignKey, 0) = 0)  ORDER BY tl.TableId, fk.name, pfkc.constraint_column_id),  IndexNames  AS (SELECT TOP 99999999  tl.TableId, CASE WHEN ix.is_primary_key = 1  OR ix.is_unique_constraint = 1 THEN ISNULL(@AddNamePrefix, '') + ix.name  ELSE ix.name  END AS IndexName, ix.is_primary_key, ix.is_unique_constraint  FROM @ObjectIdList AS tl  INNER JOIN sys.indexes AS ix WITH (NOLOCK) ON tl.object_id = ix.object_id  WHERE ix.index_id > 0  AND ix.is_disabled = 0  AND @DropIndexes = 1  ORDER BY tl.TableId, ix.type, ix.is_primary_key, ix.is_unique_constraint),  IndexColumns  AS (SELECT TOP 99999999  tl.TableId, CASE WHEN ix.is_primary_key = 1  OR ix.is_unique_constraint = 1 THEN ISNULL(@AddNamePrefix, '') + ix.name  ELSE ix.name  END AS IndexName, ix.type_desc COLLATE SQL_Latin1_General_CP1_CI_AS AS IndexType, ds.type AS DataspaceType,  ds.name AS DataspaceName, ix.is_unique, ix.is_primary_key, ix.is_unique_constraint, ix.filter_definition,  CASE WHEN @NewDataCompression = '' THEN ''  ELSE ISNULL('WITH (DATA_COMPRESSION = ' + @NewDataCompression + ')',  CASE pr.data_compression  WHEN 0 THEN ''  ELSE 'WITH (DATA_COMPRESSION = ' + pr.data_compression_desc COLLATE SQL_Latin1_General_CP1_CI_AS + ')'  END)  END AS data_compression, CASE WHEN ic.key_ordinal > 0 THEN '[' + cl.name + '] ' + CASE WHEN ic.is_descending_key = 1 THEN 'DESC'  ELSE 'ASC'  END  ELSE NULL  END AS IndexCol, CASE WHEN ic.is_included_column > 0 THEN '[' + cl.name + ']'  ELSE NULL  END AS IncludeCol, CASE WHEN ic.partition_ordinal > 0 THEN '[' + cl.name + ']'  ELSE NULL  END AS PartitionedCol  FROM @ObjectIdList AS tl  INNER JOIN sys.indexes AS ix WITH (NOLOCK) ON tl.object_id = ix.object_id  INNER JOIN sys.data_spaces AS ds WITH (NOLOCK) ON ds.data_space_id = ix.data_space_id  INNER JOIN sys.partitions AS pr WITH (NOLOCK) ON pr.object_id = ix.object_id  AND pr.index_id = ix.index_id  INNER JOIN sys.index_columns AS ic WITH (NOLOCK) ON ic.object_id = ix.object_id  AND ic.index_id = ix.index_id  INNER JOIN sys.columns AS cl WITH (NOLOCK) ON cl.object_id = ic.object_id  AND cl.column_id = ic.column_id  WHERE ix.index_id > 0  AND pr.partition_number = 1  AND ix.is_disabled = 0  AND (@CreatePrimaryKey IS NULL  OR @CreatePrimaryKey = 1  OR ix.is_primary_key = 0)  AND (@CreateUniqueKey IS NULL  OR @CreateUniqueKey = 1  OR ix.is_unique_constraint = 0)  AND (@CreateIndex IS NULL  OR @CreateIndex = 1  OR (ix.is_unique_constraint = 1  OR ix.is_primary_key = 1))  ORDER BY tl.TableId, ix.type, ix.is_primary_key, ix.is_unique_constraint, ix.index_id, ic.key_ordinal),  CheckConstraints  AS (SELECT TOP 99999999  tl.TableId, ISNULL(@AddNamePrefix, '') + ck.name AS ConstraintName, ck.definition, ck.is_disabled  FROM @ObjectIdList AS tl  INNER JOIN sys.check_constraints AS ck WITH (NOLOCK) ON ck.parent_object_id = tl.object_id  WHERE ((@IgnoreDisabledCheckConstraint = 1  AND ck.is_disabled = 0)  OR ISNULL(@IgnoreDisabledCheckConstraint, 0) = 0)  ORDER BY tl.TableId, ck.name),  AllScript  AS (SELECT 'IF EXISTS (SELECT * FROM sys.foreign_keys (NOLOCK) WHERE object_id = OBJECT_ID(N''[' + SchemaName + '].[' + KeyName  + ']'') AND parent_object_id = OBJECT_ID(N''[' + SchemaName + '].[' + TableName + ']''))     ALTER TABLE [' + SchemaName + '].[' + TableName + '] DROP CONSTRAINT [' + KeyName + ']; ' AS Script  FROM ForeignKeyNames fk  CROSS APPLY (SELECT SchemaName, TableName FROM @ObjectIdList ol WHERE ol.TableId = fk.TableId) ol  UNION ALL  SELECT 'IF EXISTS(SELECT * FROM sys.objects (NOLOCK) WHERE object_id = OBJECT_ID(''[' + SchemaName + '].[' + ConstraintName + ']''))     ALTER TABLE [' + SchemaName + '].[' + TableName + '] DROP CONSTRAINT [' + ConstraintName + ']; ' AS Script  FROM DefaultConstraintNames dc  CROSS APPLY (SELECT SchemaName, TableName FROM @ObjectIdList ol WHERE ol.TableId = dc.TableId) ol  WHERE @DropDefaultConstraints = 1  UNION ALL  SELECT 'IF OBJECT_ID(''[' + SchemaName + '].[' + TableName + ']'') IS NOT NULL     DROP TABLE [' + SchemaName + '].[' + TableName + ']; ' AS Script  FROM @ObjectIdList  WHERE @DropTable = 1  UNION ALL  SELECT 'CREATE TABLE [' + SchemaName + '].[' + TableName + '] (  ' + ColumnDef + ') ' + FileGroup + DataCompression + '; ' + CASE WHEN lock_escalation_desc <> 'TABLE' THEN ' ALTER TABLE [' + SchemaName + '].[' + TableName + '] SET (LOCK_ESCALATION = ' + lock_escalation_desc + ') ' ELSE ' '  END AS Script  FROM TableInfo ti  INNER JOIN (SELECT TableId, Util.dbo.StringConcat('[' + ColumnName + '] ' + ColumnDef, ',     ') AS ColumnDef  FROM TableColumns tc  GROUP BY TableId) tc ON ti.TableId = tc.TableId  UNION ALL  SELECT 'IF NOT EXISTS(SELECT * FROM sys.objects (NOLOCK) WHERE object_id = OBJECT_ID(''[' + SchemaName + '].[' + ConstraintName + ']''))     ALTER TABLE [' + SchemaName + '].[' + TableName + '] ADD CONSTRAINT [' + ConstraintName + '] DEFAULT ' + definition + ' FOR [' + ColumnName + ']; ' AS Script  FROM DefaultConstraintNames dc  CROSS APPLY (SELECT SchemaName, TableName FROM @ObjectIdList ol WHERE ol.TableId = dc.TableId) ol  WHERE (@CreateDefaultConstraints = 1  AND @CreateTable = 0)  UNION ALL  SELECT 'IF EXISTS (SELECT * FROM sys.indexes (NOLOCK) WHERE object_id = OBJECT_ID(N''[' + SchemaName + '].[' + TableName  + ']'') AND name = N''' + IndexName + ''') ' + CASE WHEN is_primary_key = 0  AND is_unique_constraint = 0 THEN 'DROP INDEX [' + IndexName + '] ON [' + SchemaName + '].[' + TableName + ']; ' ELSE '    ALTER TABLE [' + SchemaName + '].[' + TableName + '] DROP CONSTRAINT [' + IndexName + ']; '  END AS Script  FROM IndexNames i  CROSS APPLY (SELECT SchemaName, TableName FROM @ObjectIdList ol WHERE ol.TableId = i.TableId) ol  UNION ALL  SELECT TOP 99999999  CASE WHEN is_primary_key = 1  OR is_unique_constraint = 1  THEN 'ALTER TABLE [' + SchemaName + '].[' + TableName + '] ADD CONSTRAINT [' + IndexName + '] '  + CASE WHEN is_primary_key = 1 THEN 'PRIMARY KEY '  ELSE 'UNIQUE '  END + IndexType + ' (' + Util.dbo.StringConcat(IndexCol, ', ') + ')' + data_compression + ' '  + CASE WHEN @NewPartition <> '' THEN 'ON ' + @NewPartition  WHEN @NewFileGroup = '' THEN ''  ELSE ISNULL('ON [' + @NewFileGroup + ']',  CASE DataspaceType  WHEN 'FG' THEN 'ON [' + DataspaceName + ']'  WHEN 'PS' THEN 'ON [' + DataspaceName + '](' + Util.dbo.StringConcat(PartitionedCol, '') + ')'  WHEN 'FD' THEN ''  ELSE ''  END)  END  ELSE 'CREATE ' + CASE WHEN is_unique = 1 THEN 'UNIQUE '  ELSE ''  END + IndexType + ' INDEX [' + IndexName + '] ON [' + SchemaName + '].[' + TableName + '] ('  + Util.dbo.StringConcat(IndexCol, ', ') + ')' + ISNULL(' INCLUDE (' + Util.dbo.StringConcat(IncludeCol, ', ')  + ')', '') + ISNULL(' WHERE ' + filter_definition, '')  + data_compression + ' ' + CASE WHEN @NewPartition <> '' THEN 'ON ' + @NewPartition  WHEN @NewFileGroup = '' THEN ''  ELSE ISNULL('ON [' + @NewFileGroup + ']',  CASE DataspaceType  WHEN 'FG' THEN 'ON [' + DataspaceName + ']'  WHEN 'PS'  THEN 'ON [' + DataspaceName + ']('  + Util.dbo.StringConcat(PartitionedCol, '') + ')'  WHEN 'FD' THEN ''  ELSE ''  END)  END  END + ' ' AS Script  FROM IndexColumns ic  CROSS APPLY (SELECT SchemaName, TableName FROM @ObjectIdList ol WHERE ol.TableId = ic.TableId) ol  GROUP BY TableId, SchemaName, TableName, IndexType, is_unique, is_primary_key, is_unique_constraint, IndexName, filter_definition,  data_compression, DataspaceType, DataspaceName  ORDER BY TableId, IndexType, is_unique, is_primary_key, is_unique_constraint, IndexName  UNION ALL  SELECT 'ALTER TABLE [' + pSchemaName + '].[' + pTableName + '] ' + CASE WHEN is_disabled = 1 THEN 'WITH NOCHECK '  ELSE ''  END + 'ADD CONSTRAINT [' + KeyName + '] FOREIGN KEY ('  + Util.dbo.StringConcat('[' + pColName + ']', ', ') + ') REFERENCES [' + rSchemaName + '].[' + rTableName + '] ('  + Util.dbo.StringConcat('[' + rColName + ']', ', ') + ')' + CASE WHEN delete_referential_action > 0  THEN ' ON DELETE ' + delete_referential_action_desc  ELSE ''  END + CASE WHEN update_referential_action > 0  THEN ' ON UPDATE ' + update_referential_action_desc  ELSE ''  END  + CASE WHEN is_not_for_replication = 1 THEN ' NOT FOR REPLICATION'  ELSE ''  END + '; ' + CASE WHEN is_disabled = 1 THEN 'ALTER TABLE [' + pSchemaName + '].[' + pTableName + '] NOCHECK CONSTRAINT [' + KeyName + ']; ' ELSE ''  END AS Script  FROM ForeignKeyColumns fk  CROSS APPLY (SELECT SchemaName AS pSchemaName,  TableName AS pTableName  FROM @ObjectIdList ol  WHERE ol.TableId = fk.TableId) ol  GROUP BY TableId, pSchemaName, pTableName, KeyName, rSchemaName, rTableName, is_disabled, is_not_for_replication, delete_referential_action,  delete_referential_action_desc, update_referential_action, update_referential_action_desc  UNION ALL  SELECT 'IF EXISTS (SELECT * FROM sys.check_constraints (NOLOCK) WHERE object_id = OBJECT_ID(N''[' + SchemaName + '].[' + ConstraintName  + ']'') AND parent_object_id = OBJECT_ID(N''[' + SchemaName + '].[' + TableName + ']''))     ALTER TABLE [' + SchemaName + '].[' + TableName + '] DROP CONSTRAINT [' + ConstraintName + ']; ' AS Script  FROM CheckConstraints ck  CROSS APPLY (SELECT SchemaName, TableName FROM @ObjectIdList ol WHERE ol.TableId = ck.TableId) ol  WHERE @DropCheckConstraint = 1  UNION ALL  SELECT 'ALTER TABLE [' + SchemaName + '].[' + TableName + '] WITH ' + CASE WHEN is_disabled = 1 THEN 'NOCHECK'  ELSE 'CHECK'  END + ' ADD CONSTRAINT [' + ConstraintName + '] CHECK '  + definition + ';  ' + CASE WHEN is_disabled = 1 THEN 'ALTER TABLE [' + SchemaName + '].[' + TableName + '] NOCHECK CONSTRAINT [' + ConstraintName + ']; ' ELSE ''  END AS Script  FROM CheckConstraints ck  CROSS APPLY (SELECT SchemaName, TableName FROM @ObjectIdList ol WHERE ol.TableId = ck.TableId) ol  WHERE @CreateCheckConstraint = 1)  SELECT @SQL = ISNULL(@SQL, '') + ISNULL('USE ' + @NewDatabaseName + ' ', '') + Util.dbo.StringConcat(Script, @BatchTerminator)  FROM AllScript  OPTION (MAXDOP 1);  IF @PrintSQL = 1     BEGIN         SELECT 1 AS tag, NULL AS parent, '  ' + @SQL + '  ' AS [Q!1!Q!CDATA] FOR XML EXPLICIT     END  IF @ExecuteSQL = 1 AND @SQL <> ''     BEGIN         IF @UseTransaction = 1 BEGIN TRANSACTION          EXEC (@SQL)          IF @@ERROR = 0             BEGIN                 IF @UseTransaction = 1 AND @@TRANCOUNT > 0 COMMIT TRANSACTION                 RETURN 0             END         ELSE             BEGIN                 IF @UseTransaction = 1 AND @@TRANCOUNT > 0 ROLLBACK TRANSACTION                 RETURN 12             END     END RETURN 0 GO EXEC sys.sp_MS_marksystemobject sp_scriptmain GO USE MASTER GO IF OBJECT_ID('sp_script') IS NULL EXEC('CREATE PROCEDURE sp_script AS SELECT 1 AS ID') GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:        Gokhan Varol -- Create date: 10/05/2010 -- Description:    1. Generates create and drop scripts for tables and it's constraints -- ============================================= ALTER PROCEDURE sp_script     @ObjectName sysname = NULL, /*Fully qualified name*/     @SchemaName sysname = NULL, /* NULL for all, supports like */     @TableName sysname = NULL, /* NULL for all, supports like */     @TableList XML = NULL, /* Will overwrite @TableName */     @NewSchemaName sysname = NULL, /* NULL to scripts objects in original schema, any value overwrites */     @NewTableName sysname = NULL, /* This can be used if only one table is scripted, it will change the table name */     @NewDatabaseName sysname = NULL, /* To change the database context */     @NewFileGroup sysname = NULL, /* A new filegroup for all objects created can be given or a full partition schema with column) */     @NewPartition sysname = NULL, /* Full partition clause with the parameter like '[psDatasupplierIdTrans]([DataSupplierId])' */     @NewDataCompression sysname = NULL, /* A blank value will not script datacompression options, any value will create all objects with the new data compression */     @AddNamePrefix sysname = NULL, /* Adds a prefix to table and constraint names being created */     @ReplaceReferenceSchemaFrom sysname = NULL, /* ** For foreign key constrainst you can replace a referenced schema name @ReplaceReferenceSchemaFrom as @ReplaceReferenceSchemaTo */     @ReplaceReferenceSchemaTo sysname = NULL, /* ** Used in conjunction with @ReplaceReferenceSchemaFrom*/     @DropForeignKey BIT = 0,     @DropTable BIT = 0,     @DropDefaultConstraints BIT = 0, /* This will drop default constraints */     @DropIndexes BIT = 0, /* This will drop primary keys, unique keys and indexes */     @DropCheckConstraint BIT = 0,     @CreateTable BIT = 1, /* Table will always be created with it's defaults */     @CreateDefaultConstraints BIT = 1, /* This will create default constraints */     @CreatePrimaryKey BIT = 1,     @CreateUniqueKey BIT = 1,     @CreateIndex BIT = 1,     @CreateForeignKey BIT = 1,     @CreateCheckConstraint BIT = 1,     @IgnoreDisabledForeignKey BIT = 0,     @IgnoreDisabledCheckConstraint BIT = 0,     @UseGOBatchTerminator BIT = 0,     @SQL VARCHAR(MAX) = NULL OUTPUT, /* This will append to the passed value */     @PrintSQL BIT = 1, /* generates a single column, single row xml record */     @ExecuteSQL BIT = 0, /* Executes the generated sql statement */     @UseTransaction BIT = 0 /* SQL script will be executed within a transaction */ AS SET NOCOUNT ON /* @TableList XML Format -- SELECT s.name AS schemaname, t.name FROM sys.tables t INNER JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE s.name = 'ttrans' FOR XML RAW('Tables') <Tables schemaname="tTrans" name="Trans" /> <Tables schemaname="tTrans" name="TransAssignment" /> <Tables schemaname="tTrans" name="TransDeed" /> <Tables schemaname="tTrans" name="TransInvoluntaryLien" /> <Tables schemaname="tTrans" name="TransLegal" /> <Tables schemaname="tTrans" name="TransLegalParty" /> <Tables schemaname="tTrans" name="TransLegalPartyName" /> <Tables schemaname="tTrans" name="TransLegalPartyOrigName" /> <Tables schemaname="tTrans" name="TransLegalPartyParsed" /> <Tables schemaname="tTrans" name="TransLien" /> <Tables schemaname="tTrans" name="TransLot" /> <Tables schemaname="tTrans" name="TransPcrFields" /> <Tables schemaname="tTrans" name="TransPreForeclosure" /> <Tables schemaname="tTrans" name="TransPreForeclosureDetail" /> <Tables schemaname="tTrans" name="TransReject" /> <Tables schemaname="tTrans" name="TransRelease" /> <Tables schemaname="tTrans" name="TransSitus" /> <Tables schemaname="tTrans" name="TransText" /> */ DECLARE @ReturnVal int  EXEC @ReturnVal = sp_scriptmain     @ObjectName = @ObjectName,     @SchemaName = @SchemaName,     @TableName = @TableName,     @TableList = @TableList,     @NewSchemaName = @NewSchemaName,     @NewTableName = @NewTableName,     @NewDatabaseName = @NewDatabaseName,     @NewFileGroup = @NewFileGroup,     @NewPartition = @NewPartition,     @NewDataCompression = @NewDataCompression,     @AddNamePrefix = @AddNamePrefix,     @ReplaceReferenceSchemaFrom = @ReplaceReferenceSchemaFrom,     @ReplaceReferenceSchemaTo = @ReplaceReferenceSchemaTo,     @DropForeignKey = @DropForeignKey,     @DropTable = @DropTable,     @DropDefaultConstraints = @DropDefaultConstraints,     @DropIndexes = @DropIndexes,     @DropCheckConstraint = @DropCheckConstraint,     @CreateTable = @CreateTable,     @CreateDefaultConstraints = @CreateDefaultConstraints,     @CreatePrimaryKey = @CreatePrimaryKey,     @CreateUniqueKey = @CreateUniqueKey,     @CreateIndex = @CreateIndex,     @CreateForeignKey = @CreateForeignKey,     @CreateCheckConstraint = @CreateCheckConstraint,     @IgnoreDisabledForeignKey = @IgnoreDisabledForeignKey,     @IgnoreDisabledCheckConstraint = @IgnoreDisabledCheckConstraint,     @UseGOBatchTerminator = @UseGOBatchTerminator,     @SQL = @SQL OUTPUT,     @PrintSQL = @PrintSQL,     @ExecuteSQL = @ExecuteSQL,     @UseTransaction = @UseTransaction  RETURN @ReturnVal GO EXEC sys.sp_MS_marksystemobject sp_script GO   USE Util GO /****** Object: SqlAssembly [SQLUtil] Script Date: 01/19/2011 11:15:52 ******/ CREATE ASSEMBLY [SQLUtil] AUTHORIZATION [dbo] FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300BD0D364D0000000000000000E00002210B010800000E00000006000000000000DE2C00000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000008C2C00004F000000004000007003000000000000000000000000000000000000006000000C000000142C00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000E40C000000200000000E000000020000000000000000000000000000200000602E7273726300000070030000004000000004000000100000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000C02C000000000000480000000200050064220000B00900000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133001000B00000001000011027B030000040A2B00062A2202037D030000042A1330030039000000010000110002036F1400000A7D0200000402036F1400000A731500000A7D01000004027B010000046F1600000A16FE010A062D0802162802000006002A860003027B020000046F1700000A0003027B010000046F1800000A6F1700000A002A820002731900000A7D01000004027E1A00000A7D0200000402172802000006002A13300200A000000001000011000F01281B00000A16FE010A062D05388B0000000F02281B00000A2D140F02281C00000A6F1D00000A16FE0216FE012B01170A062D4E00027B020000047E1A00000A281E00000A16FE010A062D0D020F02281C00000A7D02000004027B010000046F1600000A16FE0216FE010A062D13027B010000040F02281C00000A6F1F00000A2600027B010000040F01281C00000A6F1F00000A2602162802000006002A13300200740000000100001100027B010000046F1600000A1631140F017B010000046F1600000A16FE0216FE012B01170A062D3300027B02000004282000000A16FE010A062D0D020F017B020000047D02000004027B01000004027B020000046F1F00000A2600027B010000040F017B010000046F1800000A6F1F00000A262A13300300320000000200001100027B010000046F1800000A0A06282000000A2D12027B010000046F1800000A732100000A2B0614732100000A0B2B00072A000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000058030000237E0000C40300007404000023537472696E67730000000038080000080000002355530040080000100000002347554944000000500800006001000023426C6F6200000000000000020000015717A2030900000000FA253300160000010000001C0000000200000003000000080000000600000001000000210000000F0000000200000001000000010000000200000002000000010000000200000000000A00010000000000060033002C000A00640049000600810075000600C700BD0006000A01BD000A00690154010600D901C7010600F601C70106001302C70106003202C70106004B02C70106006402C70106007F02C70106009A02C7010600D202B3020600E602C70106001203FF0247002603000006005503350306007503350306009B032C000A00B10349000A00D20349000600D903B3020600EF03B3020600FA03350306002B042C0006003B042C000000000001000000000001000100092110001600000005000100010001008F000A0001009C000E0001008E013D005020000000008608A700110001006720000000008108B20015000100702000000000E101D4001A000200B52000000000E101170120000300D7200000000086004F0126000400F82000000000860073012A000400A4210000000086007E0132000600242200000000860084013800070000000100AD0100000100B30100000100B50100000100AD0100000200B70100000100C10102000900110005011A001100490120003900F00144004100F00144004900F00144005100F00144005900F00144006100F00144006900F00144007100F00144007900F00115008100F00144008900F00149009900F0014F00A100F0012600A900F0012600B100F0015400C100F001BC00D100F001260021001504CB001900F001440019002004CF00290049014400D9003204CB001900F0012600E10042040E003100A700110031004804CB00E1002004CF00E1005204D30019005E04D900E1006504DF003100F001440020009B00C2002E003300FD002E003B00EA002E007B003F012E001B00EA002E002300F7002E002B00F7002E0043000C012E004B00F7002E005B00F7002E006B002D012E007300360140009B00C20043008B005A0061009B00C200C700E400020001000000A60140000200010003000100020003000200060003000200080005000480000001000000C30FB67700000000000093030000020000000000000000000000010023000000000002000000000000000000000001003D000000000000000000003C4D6F64756C653E0053514C5574696C2E646C6C00537472696E67436F6E636174006D73636F726C69620053797374656D0056616C7565547970650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E5465787400537472696E674275696C646572005F616363756D756C61746F72005F64656C696D69746572006765745F49734E756C6C007365745F49734E756C6C0053797374656D2E494F0042696E617279526561646572004D6963726F736F66742E53716C5365727665722E5365727665722E4942696E61727953657269616C697A652E5265616400526561640042696E617279577269746572004D6963726F736F66742E53716C5365727665722E5365727665722E4942696E61727953657269616C697A652E577269746500577269746500496E69740053797374656D2E446174612E53716C54797065730053716C537472696E6700416363756D756C617465004D65726765005465726D696E617465003C49734E756C6C3E6B5F5F4261636B696E674669656C640049734E756C6C0076616C7565007200770064656C696D697465720067726F75700053797374656D2E5265666C656374696F6E00417373656D626C795469746C65417474726962757465002E63746F7200417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053514C5574696C0053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174005374727563744C61796F7574417474726962757465004C61796F75744B696E6400436F6D70696C657247656E6572617465644174747269627574650052656164537472696E67006765745F4C656E677468004F626A65637400546F537472696E6700537472696E6700456D707479006765745F56616C7565006F705F457175616C69747900417070656E640049734E756C6C4F72456D70747900000003200000000000E58EA2E56ADB7A47B65FE197A3F088310008B77A5C561934E0890306120D02060E032000020420010102052001011211052001011215032000010720020111191119052001011108042000111902060203280002042001010E052001011149042001010805200101115D6101000200000004005402124973496E76617269616E74546F4F72646572005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C6963617465730054080B4D61784279746553697A65FFFFFFFF0520010111650401000000030701020320000E03200008050002020E0E052001120D0E040001020E0507020E11190C01000753514C5574696C00000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313100000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F777301000000000000BD0D364D00000000020000005C000000302C0000300E0000525344535C8E6E3588DA4E419EAF01D70A52142B04000000433A5C55736572735C677661726F6C2E4953435C446F63756D656E74735C53514C5574696C5C53514C5574696C5C6F626A5C44656275675C53514C5574696C2E70646200B42C00000000000000000000CE2C0000002000000000000000000000000000000000000000000000C02C0000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000180300000000000000000000180334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE0000010000000100B677C30F00000100B677C30F3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00478020000010053007400720069006E006700460069006C00650049006E0066006F00000054020000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000380008000100460069006C0065004400650073006300720069007000740069006F006E0000000000530051004C005500740069006C00000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0034003000330035002E00330030003600340036000000000038000C00010049006E007400650072006E0061006C004E0061006D0065000000530051004C005500740069006C002E0064006C006C0000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F0066007400200032003000310031000000000040000C0001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530051004C005500740069006C002E0064006C006C000000300008000100500072006F0064007500630074004E0061006D00650000000000530051004C005500740069006C00000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0034003000330035002E00330030003600340036000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0034003000330035002E003300300036003400360000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000E03C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WITH PERMISSION_SET = SAFE  GO  ALTER ASSEMBLY [SQLUtil] ADD FILE FROM 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000010000001B000000800000000000000018000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000281600FEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF90E1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA3101380000000010000000100000000000000C00FFFF0400000003800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A7991000000000000000BF8BDFE1499C879FE95F5A95AD72B26B070000000D0000000E0000000F000000100000001100000012000000050000001300000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A7991000000000000000BF8BDFE1499C879FE95F5A95AD72B26B000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF040000000380000000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C001000000000000C00100000000000000000000000000000000000000000000A4020000580000002C0000006C010000160000000300000006000000140000000900000008000000050000000A0000000D0000000E0000000F000000100000001100000004000000130000001200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001BE23001800000007037C5445BB7CB01040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000200000001000000010000000000000040000000280000001BE230014D23FE1C580000007E0000003F000000400000006500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B00000080000000C300000038000000FFFFFFFF00000000EC00000080000000FFFFFFFFFFFFFFFFFFFFFFFF580000000400000003000000060000000B0000000A0000000500000063730000633A5C75736572735C677661726F6C2E6973635C646F63756D656E74735C73716C7574696C5C73716C7574696C5C737472696E67636F6E6361742E637300040000003F0000000100000040000000000000000300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001BE2300180000000F62ADCF3A4B2CB01030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000200000001000000010000000000000040000000280000001BE230014D23FE1C580000007E0000003F00000040000000650000000000000000000000636F6E6361742E637300040000003F000000010000004000000000000000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF01000000BC00000000633A5C75736572735C677661726F6C2E6973635C646F63756D656E74735C53514C5574696C5C53514C5574696C5C537472696E67436F6E6361742E63730000633A5C75736572735C677661726F6C2E6973635C646F63756D656E74735C73716C7574696C5C73716C7574696C5C737472696E67636F6E6361742E637300433A5C55736572735C677661726F6C2E4953435C446F63756D656E74735C53514C5574696C5C53514C5574696C5C537472696E67436F6E6361742E63730007000000000000003F000000000000000000000001000000400000007E000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000900000078000000C300000038000000FFFFFFFF00000000A200000080000000FFFFFFFFFFFFFFFFFFFFFFFF580000000700000003000000060000000900000008000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000005A002A11000000003801000000000000390000000000000000000000030000060000000001000000004D6963726F736F66742E53716C5365727665722E5365727665722E4942696E61727953657269616C697A652E526561640000001600031104000000040100003900000000000000010000000A0024115553797374656D001A0024115553797374656D2E446174612E53716C54797065730000000E0024115553797374656D2E494F0000120024115553797374656D2E54657874000000001E002411554D6963726F736F66742E53716C5365727665722E536572766572001E00201100000000010000110000000000000400435324342430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040000000C00000001000500020006005A002A1100000000C801000000000000210000000000000000000000040000063900000001000000004D6963726F736F66742E53716C5365727665722E5365727665722E4942696E61727953657269616C697A652E577269746500002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040127000C00000003000006020006002E002A11000000002C02000000000000200000000000000000000000050000065A0000000100000000496E69740000002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040127000C000000030000060200060032002A1100000000D002000000000000A00000000000000000000000060000067A0000000100000000416363756D756C6174650016000311300200009C020000A00000007A000000010000001E00201100000000010000110000000000000400435324342430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040127000C00000003000006020006002E002A11000000007003000000000000740000000000000000000000070000061A01000001000000004D65726765000016000311D40200003C030000740000001A010000010000001E00201100000000010000110000000000000400435324342430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040127000C000000030000060200060032002A11000000003004000000000000320000000000000000000000080000068E01000001000000005465726D696E61746500001600031174030000FC030000320000008E010000010000001E002011010000000200001100000000000004004353243124303030300000001A00201100000000020000110000000000000000726573756C740000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D00440032000000040100000401B3570C0000000300000602000600F20000006C000000000000000100010039000000000000000700000060000000000000002000008001000000210000800D000000220000801E000000230000802D000000EEEFFE8030000000230000803800000024000080050006000900250009003A0009002600000000002700360005000600F20000004800000039000000010001002100000000000000040000003C000000000000002B000080010000002C0000800E0000002D000080200000002E0000800500060009001D0009002A0005000600F2000000540000005A0000000100010020000000000000000500000048000000000000003300008001000000340000800C0000003500008017000000360000801F000000370000800500060009002C00090023000900170005000600F2000000E40000007A00000001000100A00000000000000011000000D8000000000000003A000080010000003B0000800C000000EEEFFE800F0000003B000080140000003C00008033000000EEEFFE80360000003D000080370000003E0000804B000000EEEFFE804E0000003E0000805B0000003F0000806D000000EEEFFE80700000003F0000808300000040000080840000004100008097000000420000809F000000430000800500060009001A00000000001B00220009003D000000000009000A000D002C00000000002D004A000D002900000000002A004F0009000A0009002A000900180005000600F20000009C0000001A0100000100010074000000000000000B00000090000000000000004A000080010000004C00008025000000EEEFFE80280000004D000080290000004E00008038000000EEEFFE803B0000004F00008048000000500000805A000000510000805B00000052000080730000005300008005000600090046000000000009000A000D0032000000000011002F000D002D0009000A0009003C0005000600F2000000480000008E010000010001003200000000000000040000003C000000000000005600008001000000570000800D0000005800008030000000590000800500060009002E0009006C0005000600F4000000080000007E000000000000003000000000000000400000005800000098000000B0000000C4000000DC000000F800000010010000240100003C0100005401000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000FFFFFFFF1A092FF160000000340200004100000001000000DD00000001000000F9000000010000003D0100000100000025010000010000009900000001000000C500000001000000B1000000010000005501000001000000010000000100000011010000010000005900000001000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000200000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C0000001800000024000000300000003C0000004800000054000000600000006C00000078000000840000000100303630303030303400001200251100000000CC0100000100496E697400001600291100000000CC0100000100303630303030303500001A00251100000000300200000100416363756D756C617465000000001600291100000000300200000100303630303030303600001200251100000000D402000001004D65726765001600291100000000D402000001003036303030303037000016002511000000007403000001005465726D696E61746500160029110000000074030000010030363030303030380000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E002511000000000400000001004D6963726F736F66742E53716C5365727665722E5365727665722E4942696E61727953657269616C697A652E5265616400001600291100000000040000000100303630303030303300003E002511000000003C01000001004D6963726F736F66742E53716C5365727665722E5365727665722E4942696E61727953657269616C697A652E57726974650016002911000000003C0100000100303630303030303400001200251100000000CC0100000100496E697400001600291100000000CC0100000100303630303030303500001A00251100000000300200000100416363756D756C617465000000001600291100000000300200000100303630303030303600001200251100000000D402000001004D65726765001600291100000000D402000001003036303030303037000016002511000000007403000001005465726D696E617465001600291100000000740300000100303630303030303800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF100000000000000006E61727953657269616C697A652E5265616400001600291100000000040000000100303630303030303300003E002511000000003C01000001004D6963726F736F66742E53716C5365727665722E5365727665722E4942696E61727953657269616C697A652E57726974650016002911000000003C0100000100303630303030303400001200251100000000CC0100000100496E697400001600291100000000CC0100000100303630303030303500001A00251100000000300200000100416363756D756C617465000000001600291100000000300200000100303630303030303600001200251100000000D402000001004D65726765001600291100000000D402000001003036303030303037000016002511000000007403000001005465726D696E6174650016002911000000007403000001003036303030303038000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFFFFFF77093101040000000900008A0E006F760B00010058000000AC0000002C0000004C000000000000000000000016000000190000000000EEC00000000000000000FFFF000000000000FFFFFFFF00000000FFFF000000000000000000000000080034040000000000001003000001000000B8C1B6050000000000000000537472696E67436F6E6361740042384530334533440000002DBA2EF10100000000000000390000000000000000000000000000000000000001000000390000002100000000000000000000000000000000000000010000005A0000002000000000000000000000000000000000000000010000007A000000A000000000000000000000000000000000000000010000001A0100007400000000000000000000000000000000000000010000008E0100003200000000000000000000000000000000000000020002000D01000000000100FFFFFFFF00000000C00100000802000000000000FFFFFFFF00000000FFFFFFFF010001000000010000000000433A5C55736572735C677661726F6C2E4953435C446F63756D656E74735C53514C5574696C5C53514C5574696C5C537472696E67436F6E6361742E6373000000FEEFFEEF010000000100000000010000000000000000000000FFFFFFFFFFFFFFFFFFFF0700FFFFFFFFFFFFFFFFFFFF000000000000000000000000000000000000000000942E310191242E4D040000005C8E6E3588DA4E419EAF01D70A52142B6B0000002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F633A5C75736572735C677661726F6C2E6973635C646F63756D656E74735C73716C7574696C5C73716C7574696C5C737472696E67636F6E6361742E6373000400000006000000010000001E000000000000001100000006000000220000000A0000000A000000050000000000000004000000000000000000000000000000000000000000000000010000005A0000002000000000000000000000000000000000000000010000007A000000A000000000000000000000000000000000000000010000001A0100007400000000000000000000000000000000000000010000008E0100003200000000000000000000000000000000000000020002000D01000000000100FFFFFFFF00000000C00100000802000000000000FFFFFFFF00000000FFFFFFFF01000100000001003E000000633A5C75736572735C677661726F6C2E6973635C646F63756D656E74735C53514C5574696C5C53514C5574696C5C537472696E67436F6E6361742E637300433A5C55736572735C677661726F6C2E4953435C446F63756D656E74735C53514C5574696C5C53514C5574696C5C537472696E67436F6E6361742E637300FEEFFEEF010000000F00000048000000C300000038000000EB01000000000000EC000000800000002800000078070000A4020000580000006C010000FFFFFFFFFFFFFFFF2C000000090000001600000006000000150000000B00000008000000070000000D0000000E0000000F0000001000000011000000120000000400000013000000140000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001700000091242E4D030000005C8E6E3588DA4E419EAF01D70A52142B6B0000002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F633A5C75736572735C677661726F6C2E6973635C646F63756D656E74735C73716C7574696C5C73716C7574696C5C737472696E67636F6E6361742E6373000400000006000000010000001E000000000000001100000006000000220000000A0000000A0000000500000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E00000048000000C3000000380000002702000000000000EC000000800000002800000078070000A4020000580000006C010000FFFFFFFF2C0000000C000000180000000600000016000000170000000B0000000A000000070000000D0000000E0000000F0000001000000011000000120000000500000013000000140000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 AS N'bin\Debug\SQLUtil.pdb'  GO  ALTER ASSEMBLY [SQLUtil] ADD FILE FROM 0xEFBBBF7573696E672053797374656D2E5265666C656374696F6E3B0D0A7573696E672053797374656D2E52756E74696D652E436F6D70696C657253657276696365733B0D0A7573696E672053797374656D2E52756E74696D652E496E7465726F7053657276696365733B0D0A7573696E672053797374656D2E446174612E53716C3B0D0A0D0A2F2F2047656E6572616C20496E666F726D6174696F6E2061626F757420616E20617373656D626C7920697320636F6E74726F6C6C6564207468726F7567682074686520666F6C6C6F77696E670D0A2F2F20736574206F6620617474726962757465732E204368616E6765207468657365206174747269627574652076616C75657320746F206D6F646966792074686520696E666F726D6174696F6E0D0A2F2F206173736F636961746564207769746820616E20617373656D626C792E0D0A5B617373656D626C793A20417373656D626C795469746C65282253514C5574696C22295D0D0A5B617373656D626C793A20417373656D626C794465736372697074696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6E66696775726174696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6D70616E7928224D6963726F736F667422295D0D0A5B617373656D626C793A20417373656D626C7950726F64756374282253514C5574696C22295D0D0A5B617373656D626C793A20417373656D626C79436F707972696768742822436F7079726967687420C2A9204D6963726F736F6674203230313122295D0D0A5B617373656D626C793A20417373656D626C7954726164656D61726B282222295D0D0A5B617373656D626C793A20417373656D626C7943756C74757265282222295D0D0A0D0A5B617373656D626C793A20436F6D56697369626C652866616C7365295D0D0A0D0A2F2F0D0A2F2F2056657273696F6E20696E666F726D6174696F6E20666F7220616E20617373656D626C7920636F6E7369737473206F662074686520666F6C6C6F77696E6720666F75722076616C7565733A0D0A2F2F0D0A2F2F2020202020204D616A6F722056657273696F6E0D0A2F2F2020202020204D696E6F722056657273696F6E0D0A2F2F2020202020204275696C64204E756D6265720D0A2F2F2020202020205265766973696F6E0D0A2F2F0D0A2F2F20596F752063616E207370656369667920616C6C207468652076616C756573206F7220796F752063616E2064656661756C7420746865205265766973696F6E20616E64204275696C64204E756D626572730D0A2F2F206279207573696E672074686520272A272061732073686F776E2062656C6F773A0D0A5B617373656D626C793A20417373656D626C7956657273696F6E2822312E302E2A22295D0D0A0D0A AS N'Properties\AssemblyInfo.cs'  GO  ALTER ASSEMBLY [SQLUtil] ADD FILE FROM 0xEFBBBF7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174612E53716C54797065733B0D0A7573696E672053797374656D2E494F3B0D0A7573696E672053797374656D2E546578743B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A0D0A5B53657269616C697A61626C655D0D0A5B53716C55736572446566696E6564416767726567617465280D0A20202020466F726D61742E55736572446566696E65642C202F2F2042696E6172792053657269616C697A6174696F6E2062656361757365206F6620537472696E674275696C6465720D0A202020204973496E76617269616E74546F4F72646572203D2066616C73652C202F2F206F72646572206368616E6765732074686520726573756C740D0A202020204973496E76617269616E74546F4E756C6C73203D20747275652C202F2F206E756C6C7320646F6E2774206368616E67652074686520726573756C740D0A202020204973496E76617269616E74546F4475706C696361746573203D2066616C73652C202F2F206475706C696361746573206368616E67652074686520726573756C740D0A202020204D61784279746553697A65203D202D310D0A20202020295D0D0A7075626C69632073747275637420537472696E67436F6E636174203A204942696E61727953657269616C697A650D0A7B0D0A202020207072697661746520537472696E674275696C646572205F616363756D756C61746F723B0D0A202020207072697661746520737472696E67205F64656C696D697465723B0D0A0D0A202020202F2F2F203C73756D6D6172793E0D0A202020202F2F2F20202049734E756C6C2070726F70657274790D0A202020202F2F2F203C2F73756D6D6172793E0D0A202020207075626C696320426F6F6C65616E2049734E756C6C207B206765743B2070726976617465207365743B207D0D0A0D0A2020202023726567696F6E204942696E61727953657269616C697A65204D656D626572730D0A0D0A202020202F2F2F203C73756D6D6172793E0D0A202020202F2F2F202020446573657269616C697A652066726F6D207468652072656164657220746F20726563726561746520746865207374727563740D0A202020202F2F2F203C2F73756D6D6172793E0D0A202020202F2F2F203C706172616D206E616D65203D202272223E42696E6172795265616465723C2F706172616D3E0D0A20202020766F6964204942696E61727953657269616C697A652E526561642842696E6172795265616465722072290D0A202020207B0D0A20202020202020205F64656C696D69746572203D20722E52656164537472696E6728293B0D0A20202020202020205F616363756D756C61746F72203D206E657720537472696E674275696C64657228722E52656164537472696E672829293B0D0A2020202020202020696620285F616363756D756C61746F722E4C656E67746820213D2030292049734E756C6C203D2066616C73653B0D0A202020207D0D0A0D0A202020202F2F2F203C73756D6D6172793E0D0A202020202F2F2F20202053657269616C697A6520746865207374727563742E0D0A202020202F2F2F203C2F73756D6D6172793E0D0A202020202F2F2F203C706172616D206E616D65203D202277223E42696E6172795772697465723C2F706172616D3E0D0A20202020766F6964204942696E61727953657269616C697A652E57726974652842696E6172795772697465722077290D0A202020207B0D0A2020202020202020772E5772697465285F64656C696D69746572293B0D0A2020202020202020772E5772697465285F616363756D756C61746F722E546F537472696E672829293B0D0A202020207D0D0A0D0A2020202023656E64726567696F6E0D0A0D0A202020207075626C696320766F696420496E697428290D0A202020207B0D0A20202020202020205F616363756D756C61746F72203D206E657720537472696E674275696C64657228293B0D0A20202020202020205F64656C696D69746572203D20737472696E672E456D7074793B0D0A202020202020202049734E756C6C203D20747275653B0D0A202020207D0D0A0D0A202020207075626C696320766F696420416363756D756C6174652853716C537472696E672076616C75652C2053716C537472696E672064656C696D69746572290D0A202020207B0D0A20202020202020206966202876616C75652E49734E756C6C292072657475726E3B0D0A2020202020202020696620282164656C696D697465722E49734E756C6C2026262064656C696D697465722E56616C75652E4C656E677468203E2030290D0A20202020202020207B0D0A202020202020202020202020696620285F64656C696D69746572203D3D20537472696E672E456D70747929205F64656C696D69746572203D2064656C696D697465722E56616C75653B0D0A202020202020202020202020696620285F616363756D756C61746F722E4C656E677468203E203029205F616363756D756C61746F722E417070656E642864656C696D697465722E56616C7565293B0D0A20202020202020207D0D0A20202020202020205F616363756D756C61746F722E417070656E642876616C75652E56616C7565293B0D0A202020202020202049734E756C6C203D2066616C73653B0D0A202020207D0D0A0D0A202020202F2F2F203C73756D6D6172793E0D0A202020202F2F2F2020204D65726765206F6E746F2074686520656E640D0A202020202F2F2F203C2F73756D6D6172793E0D0A202020202F2F2F203C706172616D206E616D65203D202267726F7570223E3C2F706172616D3E0D0A202020207075626C696320766F6964204D6572676528537472696E67436F6E6361742067726F7570290D0A202020207B0D0A20202020202020202F2F20616464207468652064656C696D69746572206265747765656E20737472696E67730D0A2020202020202020696620285F616363756D756C61746F722E4C656E677468203E20302026262067726F75702E5F616363756D756C61746F722E4C656E677468203E2030290D0A20202020202020207B0D0A20202020202020202020202069662028537472696E672E49734E756C6C4F72456D707479285F64656C696D6974657229290D0A202020202020202020202020202020205F64656C696D69746572203D2067726F75702E5F64656C696D697465723B0D0A2020202020202020202020205F616363756D756C61746F722E417070656E64285F64656C696D69746572293B0D0A20202020202020207D0D0A20202020202020205F616363756D756C61746F722E417070656E642867726F75702E5F616363756D756C61746F722E546F537472696E672829293B0D0A202020207D0D0A0D0A202020207075626C69632053716C537472696E67205465726D696E61746528290D0A202020207B0D0A202020202020202076617220726573756C74203D205F616363756D756C61746F722E546F537472696E6728293B0D0A202020202020202072657475726E20537472696E672E49734E756C6C4F72456D70747928726573756C7429203F206E65772053716C537472696E67286E756C6C29203A206E65772053716C537472696E67285F616363756D756C61746F722E546F537472696E672829293B0D0A202020207D0D0A7D0D0A AS N'StringConcat.cs'  GO  EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyProjectRoot', @value=N'C:\Users\gvarol.ISC\Documents\SQLUtil\SQLUtil' , @level0type=N'ASSEMBLY',@level0name=N'SQLUtil' GO     /****** Object: UserDefinedAggregate [dbo].[StringConcat] Script Date: 01/18/2011 17:12:34 ******/ CREATE AGGREGATE [dbo].[StringConcat] (@value [nvarchar](MAX), @delimiter [nvarchar](4000)) RETURNS[nvarchar]( MAX) EXTERNAL NAME [SQLUtil].[StringConcat] GO  EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile', @value=N'StringConcat.cs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'AGGREGATE',@level1name=N'StringConcat' GO  EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFileLine', @value=N'58' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'AGGREGATE',@level1name=N'StringConcat' GO    // Source code for the aggregate  using System; using System.Data.SqlTypes; using System.IO; using System.Text; using Microsoft.SqlServer.Server;  [Serializable] [SqlUserDefinedAggregate(  Format.UserDefined, // Binary Serialization because of StringBuilder  IsInvariantToOrder = false, // order changes the result  IsInvariantToNulls = true, // nulls don't change the result  IsInvariantToDuplicates = false, // duplicates change the result  MaxByteSize = -1  )] public struct StringConcat : IBinarySerialize {  private StringBuilder _accumulator;  private string _delimiter;   /// <summary>  /// IsNull property  /// </summary>  public Boolean IsNull { get; private set; }   #region IBinarySerialize Members   /// <summary>  /// Deserialize from the reader to recreate the struct  /// </summary>  /// <param name = "r">BinaryReader</param>  void IBinarySerialize.Read(BinaryReader r)  {  _delimiter = r.ReadString();  _accumulator = new StringBuilder(r.ReadString());  if (_accumulator.Length != 0) IsNull = false;  }   /// <summary>  /// Serialize the struct.  /// </summary>  /// <param name = "w">BinaryWriter</param>  void IBinarySerialize.Write(BinaryWriter w)  {  w.Write(_delimiter);  w.Write(_accumulator.ToString());  }   #endregion   public void Init()  {  _accumulator = new StringBuilder();  _delimiter = string.Empty;  IsNull = true;  }   public void Accumulate(SqlString value, SqlString delimiter)  {  if (value.IsNull) return;  if (!delimiter.IsNull && delimiter.Value.Length > 0)  {  if (_delimiter == String.Empty) _delimiter = delimiter.Value;  if (_accumulator.Length > 0) _accumulator.Append(delimiter.Value);  }  _accumulator.Append(value.Value);  IsNull = false;  }   /// <summary>  /// Merge onto the end  /// </summary>  /// <param name = "group"></param>  public void Merge(StringConcat group)  {  // add the delimiter between strings  if (_accumulator.Length > 0 && group._accumulator.Length > 0)  {  if (String.IsNullOrEmpty(_delimiter))  _delimiter = group._delimiter;  _accumulator.Append(_delimiter);  }  _accumulator.Append(group._accumulator.ToString());  }   public SqlString Terminate()  {  var result = _accumulator.ToString();  return String.IsNullOrEmpty(result) ? new SqlString(null) : new SqlString(_accumulator.ToString());  } }
SQL Server & MSBI

Pages

Feb 3, 2011

Stored procedure to script tables

No comments:

Post a Comment
