GeorgeDellinger

# Not only have we been adding wands, but our users have been adding new ones daily! Lets create a list of all the unique wand makers in our database.

db.wands.aggregate(
  {
    "$group": {
      "_id": "$maker"
    }
  }
)

GeorgeDellinger

using (WorkflowRuntime workflowRuntime = new WorkflowRuntime())
{
    WorkflowInstance wfi = workflowRuntime.CreateWorkflow(typeof (WorkflowActivity), parameters);
    wfi.Start();
}

GeorgeDellinger

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
   <system.diagnostics>
      <switches>
         <add name="DisableWorkflowDebugging" value="true"/>
      </switches>
   </system.diagnostics>
</configuration>

GeorgeDellinger

Create table #yourcolumndetails(DBaseName varchar(100), TableSchema varchar(50), TableName varchar(100),ColumnName varchar(100), DataType varchar(100), CharMaxLength varchar(100))

EXEC sp_MSForEachDB @command1='USE [?];
    INSERT INTO #yourcolumndetails SELECT
    Table_Catalog
    ,Table_Schema
    ,Table_Name
    ,Column_Name
    ,Data_Type
    ,Character_Maximum_Length

GeorgeDellinger

        public static ISomeInterface GetInstance(string record)
        {
            var instances = from t in Assembly.GetExecutingAssembly().GetTypes()
                            where t.GetInterfaces().Contains(typeof(ISomeInterface))
                                  && t.GetConstructor(Type.EmptyTypes) != null
                            orderby t.Name
                            select Activator.CreateInstance(t) as ISomeInterface;


            return (from instance in instances

GeorgeDellinger

USE [master]
GO
/****** Object:  StoredProcedure [dbo].[sp_SearchStoredProcedures]    Script Date: 05/17/2013 08:02:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_SearchStoredProcedures]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_SearchStoredProcedures]

GeorgeDellinger

USE [master]
GO
/****** Object:  StoredProcedure [dbo].[sp_FindTablesIncludeSynonyms]    Script Date: 05/17/2013 08:02:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_FindTablesIncludeSynonyms]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_FindTablesIncludeSynonyms]

GeorgeDellinger

SET NOCOUNT ON
GO

PRINT 'Using Master database'
USE master
GO

PRINT 'Checking for the existence of this procedure'
IF (SELECT OBJECT_ID('dbo.sp_generate_inserts','P')) IS NOT NULL --means, the procedure already exists
    BEGIN

GeorgeDellinger

USE [master]
GO
/****** Object:  StoredProcedure [dbo].[sp_FindColumnsIncludeSynonyms]    Script Date: 05/17/2013 08:02:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_FindColumnsIncludeSynonyms]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_FindColumnsIncludeSynonyms]

GeorgeDellinger

SET NOCOUNT ON
declare @tempTable table
(
    TableSchema nvarchar(256),
    TableName nvarchar(256),
    ColumnName sysname
);

declare @sql nvarchar(4000);
declare @tableSchema nvarchar(256);