afscrome

<#
This is a begining of a script that will allow you to install a Telligent instance onto a clean vm.

Prequisites:
* Powershell 5 - https://www.microsoft.com/en-us/download/details.aspx?id=50395
* SQL 2016 - http://go.microsoft.com/fwlink/?LinkID=799009
SQL May be automatable, needs some more work.  Powershell is not easily automatable as
installation of Powershell 5 will require a reboot, which will interupt script execution
#>

afscrome

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="11.0.5343.0">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementText="CREATE PROCEDURE nre_repo&#xD;&#xA;AS&#xD;&#xA;BEGIN&#xD;&#xA;&#x9;CREATE TABLE #replies ( Id int NOT NULL PRIMARY KEY );&#xD;&#xA;&#xD;&#xA;" StatementId="1" StatementCompId="52" StatementType="CREATE TABLE" RetrievedFromCache="true" />
        <StmtSimple StatementText="&#x9;Insert Into #replies&#xD;&#xA;&#x9;exec sp_executesql N'select 1'&#xD;&#xA;&#xD;&#xA;" StatementId="2" StatementCompId="53" StatementType="INSERT EXEC" RetrievedFromCache="true" StatementSubTreeCost="0.0132841" StatementEstRows="1" StatementOptmLevel="TRIVIAL" QueryHash="0xD6FBD67832A8F4DD" QueryPlanHash="0xD754250DFD9DD669">
          <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
          <QueryPlan CachedP