locked
Code First and IsolationLevels RRS feed

  • Question

  • User1374623307 posted

    Hello,

         While trying to implement a database to a front-end a rather large problem was encountered.  First off the database is in SQL Server 2014, and has Snapshot Isolation allowed.  Due to the work done on a few of the stored procedures, plus the fact that some required tables will not show in any model of Entity Framework, we have been required to use them.  So we went with a EF6 Code First from Existing Database.   From there the Model was adjusted in the Fluent API to incorporate the stored procedures, which was no big deal, we mapped the procedure to the table that the procedure is initially used for and ensured that the parameters matched.  A Controller was then created for that table, using async controller methods.  A test was run, and it failed with the following:

     System.Data.SqlClient.SqlException: Transaction failed in database 'DB' because the statement was run under snapshot isolation but the transaction did not start in snapshot isolation. You cannot change the isolation level of the transaction to snapshot after the transaction has started unless the transaction was originally started under snapshot isolation level.

    It highlighted the await db.SaveChangesAsync() as the problem area.

    Removal of the Controller and building it without the Async controller methods, resulted in the same issue, but first we were presented with an unhandled exception.  Further discussion led to the DBAs removing the Snapshot isolation from the stored procedures.  Again trying it with the no async methods led to invalid object state.  Controller was removed, and created again (no async), again invalid object state.  Remove the controller and created with async, and again invalid object state.  The DBAs then added the Snapshot back into the database and the stored procedures, and back to the isolation level issue.

    Now a few things have been tried with no success.  A private DbContextTransaction _ContextTransaction; was added to the model, and then _ContextTransaction = Database.BeginTransaction(isolationLevel Snapshot) was added to the model.  This resulted in the .BeginTransaction giving an error stating that the method was being used as a type.  This was removed and we moved to the controller and added a using statement into the create function to try and get the isolationLevel to work.  Regrettably it did not like the using statement and wouldn't run.  So we are looking for help on how to fix this issue, if anyone has any ideas on where to point us for this.  Thank you.

    Wednesday, August 19, 2015 4:48 PM

All replies

  • User1374623307 posted

    Ok here is what I am working with to give a better understanding of what is going on.

    Here is the stored procedure that works perfectly fine in TSQL:

    	-- Add the parameters for the stored procedure here
    	@Emp_First_Name varchar( 20 ),
    	@Emp_Last_Name varchar( 20 ) NULL,
            @Emp_Gender varchar( 7 ),
    	@Profession_Profession_ID int,
    WITH EXECUTE AS OWNER
    AS BEGIN
    	BEGIN TRY
    	SET TRANSACTION ISOLATION LEVEL SNAPSHOT
    	BEGIN TRANSACTION
    	-- SET NOCOUNT ON added to prevent extra result sets from
    	-- interfering with SELECT statements.
    	SET NOCOUNT ON;
    
        -- Insert statements for procedure here
    	DECLARE @Emp_ID int
    	SELECT @Emp_ID = IDENT_CURRENT( N'Employee' ) + 1 --SCOPE_IDENTITY() was formerly used, but did not work.  Hope that IDENT_CURRENT works.	 Works perfectly
    	INSERT INTO Employee (  -- Inserts into Employee all relevant info 
    	Emp_First_Name,
    	Emp_Last_Name,
    	Emp_Gender,
    	Profession_Profession_ID,
    	VALUES (
    	@Emp_First_Name,
    	@Emp_Last_Name,
    	@Emp_Gender,
    	@Profession_Profession_ID)
    	CREATE TABLE #TempTrade ( idx int PRIMARY KEY IDENTITY( 1,1 ), Emp_ID int, Trade_ID int, Trade_Level_ID int, Level_Mastery int )  -- Creates the temporary table
    	INSERT INTO #TempTrade ( Trade_ID ) -- inserts the Trades that relate to the profession into that table
    		SELECT TradeClass_Trade_Class_ID
    		FROM TradeProfession
    		WHERE Profession_Profession_ID = @Profession_Profession_ID  
    	UPDATE #TempTrade -- adds Emp_ID, Trade_Level Apprentice, and No Mastery to all rows
    	SET Emp_ID = @Emp_ID,
    		Emp_Level_ID = 1,
    		Level_Mastery = 0	
    	INSERT INTO EmployeeTrade(
    		Employee_Char_ID,
    		TradeClass_Trade_Class_ID,
    		TradeLevel_Trade_Level_ID,
    		Trade_Level_Mastery)
    	SELECT Emp_ID, Trade_ID, Trade_Level_ID, Level_Mastery FROM #TempTrade  -- inserts the temp table into EmployeeTrade
    	DROP TABLE #TempTrade  -- drops the temp table..... THIS IS EXTREMELY IMPORTANT!!!!
    	COMMIT TRANSACTION
    END TRY
    BEGIN CATCH
    	THROW;
    	ROLLBACK TRANSACTION
    END CATCH
    END

    and here is the controller for the employeecontroller.cs focused on the Create

    // GET: Employees/Create
            public ActionResult Create()
                {
                ViewBag.Profession_Profession_ID = new SelectList(db.Professions, "Profession_ID", "Profession_Name");
                return View();
                }
    
            // POST: Employees/Create
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see http://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public async Task<ActionResult> Create([Bind(Include = "Emp_ID,Emp_First_Name,Emp_Last_Name,Emp_Gender,Profession_Profession_ID")] Character character)
                {
                if (ModelState.IsValid)
                    {
                    db.Employees.Add(employee);
                    await db.SaveChangesAsync();
                    return RedirectToAction("Index");
                    }
    
                ViewBag.Profession_Profession_ID = new SelectList(db.Professions, "Profession_ID", "Profession_Name", employee.Profession_Profession_ID);
                return View(employee);
                }

    and lastly from the model here is the code:

    namespace EmpMVC.Models
        {
        using System;
        using System.Data.Entity;
        using System.ComponentModel.DataAnnotations.Schema;
        using System.Linq;
    
        public partial class EmpModel : DbContext
            {
            public EmpModel()
                : base("name=EmpModel")
                {
                }
    
            public virtual DbSet<Employee> Employees { get; set; }
            public virtual DbSet<EmployeeTrade> EmployeeTrades { get; set; }
            public virtual DbSet<TradeClass> TradeClasses { get; set; }
            public virtual DbSet<TradeLevel> TradeLevels { get; set; }
            public virtual DbSet<Profession> Professions { get; set; }
            
            protected override void OnModelCreating(DbModelBuilder modelBuilder)
                {
                modelBuilder.Entity<Employee>()
                    .MapToStoredProcedures(sp =>
                    {
                        sp.Insert(i => i.HasName("InsertEmployeeTry2"));
                        sp.Update(u => u.HasName("UpdateEmployee2"));
                    }
                    );
    
                modelBuilder.Entity<Employee>()
                    .Property(e => e.Emp_First_Name)
                    .IsUnicode(false);
    
                modelBuilder.Entity<Employee>()
                    .Property(e => e.Emp_Last_Name)
                    .IsUnicode(false);
    
                modelBuilder.Entity<Employee>()
                    .Property(e => e.Emp_Gender)
                    .IsUnicode(false);
    
                modelBuilder.Entity<Employee>()
                    .HasMany(e => e.EmployeeTrades)
                    .WithRequired(e => e.Employee)
                    .HasForeignKey(e => e.Employee_Emp_ID);
    
                modelBuilder.Entity<TradeClass>()
                    .Property(e => e.Trade_Class_Name)
                    .IsUnicode(false);
    
                modelBuilder.Entity<TradeClass>()
                    .HasMany(e => e.EmployeeTrades)
                    .WithRequired(e => e.TradeClass)
                    .HasForeignKey(e => e.TradeClass_Trade_Class_ID);
    
                modelBuilder.Entity<TradeClass>()
                    .HasMany(e => e.Professions)
                    .WithMany(e => e.TradeClasses)
                    .Map(m => m.ToTable("TradeProfession"));
    
                modelBuilder.Entity<TradeLevel>()
                    .Property(e => e.Trade_Level_Name)
                    .IsUnicode(false);
    
                modelBuilder.Entity<TradeLevel>()
                    .HasMany(e => e.EmployeeTrades)
                    .WithRequired(e => e.TradeLevel)
                    .HasForeignKey(e => e.TradeLevel_Trade_Level_ID)
                    .WillCascadeOnDelete(false);
    
                modelBuilder.Entity<Profession>()
                    .Property(e => e.Profession_Name)
                    .IsUnicode(false);
    
                modelBuilder.Entity<Profession>()
                    .HasMany(e => e.Employees)
                    .WithRequired(e => e.Profession)
                    .HasForeignKey(e => e.Profession_Profession_ID);
    
                }
            }
        }

    So still looking for help as to where I would change the transaction isolationLevel in that.  As I stated removing the Transaction Isolation Level from the Stored Procedures brings out an invalid Object State.  While stored procedure still works by using it from SSMS it will not work from the web page.  Thank you.

    Monday, August 24, 2015 2:11 PM
  • User1374623307 posted

    Here is a last bit of troubleshooting I have done.  I have two XML files currently, both were made from SQL Profiler.  One shows how the connections from ASP.Net to SQL Server were done, and the other shows from SSMS.  The one from ASP.Net is a failure, while the one from SSMS is a success. 

    From ASP.Net:

    <?xml version="1.0" encoding="utf-16"?>
    <TraceData xmlns="http://tempuri.org/TracePersistence.xsd">
      <Header>
        <TraceProvider name="Microsoft SQL Server" MajorVersion="12" MinorVersion="0" BuildNumber="4213" />
        <ServerInformation name="MRM2SQL\MRM2SQLS2" />
        <ProfilerUI>
          <OrderedColumns>
            <ID>27</ID>
            <ID>1</ID>
            <ID>3</ID>
            <ID>35</ID>
            <ID>22</ID>
            <ID>34</ID>
            <ID>26</ID>
            <ID>2</ID>
            <ID>12</ID>
            <ID>14</ID>
            <ID>49</ID>
            <ID>11</ID>
          </OrderedColumns>
          <TracedEvents>
            <Event id="14">
              <EventColumn id="1" />
              <EventColumn id="2" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="35" />
            </Event>
            <Event id="15">
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="35" />
            </Event>
            <Event id="17">
              <EventColumn id="1" />
              <EventColumn id="2" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="35" />
            </Event>
            <Event id="11">
              <EventColumn id="1" />
              <EventColumn id="2" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="34" />
              <EventColumn id="35" />
            </Event>
            <Event id="43">
              <EventColumn id="1" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="22" />
              <EventColumn id="26" />
              <EventColumn id="34" />
              <EventColumn id="35" />
            </Event>
            <Event id="42">
              <EventColumn id="1" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="22" />
              <EventColumn id="26" />
              <EventColumn id="34" />
              <EventColumn id="35" />
            </Event>
            <Event id="44">
              <EventColumn id="1" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="22" />
              <EventColumn id="26" />
              <EventColumn id="34" />
              <EventColumn id="35" />
            </Event>
            <Event id="13">
              <EventColumn id="1" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="35" />
            </Event>
          </TracedEvents>
        </ProfilerUI>
      </Header>
      <Events>
        <Event id="65534" name="Trace Start">
          <Column id="14" name="StartTime">2015-08-25T17:45:39.303-04:00</Column>
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010000000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">54</Column>
          <Column id="14" name="StartTime">2015-08-25T14:21:08.123-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort on
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">6008002838F4050000000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">58</Column>
          <Column id="14" name="StartTime">2015-08-25T17:43:09.647-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010001000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:44:55.247-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort on
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">6008002838F4050000000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">61</Column>
          <Column id="14" name="StartTime">2015-08-25T17:43:14.72-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort on
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">6008002838F4050000000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:41:14.3-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:44:55.247-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="35" name="DatabaseName" />
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010001000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:58.673-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="35" name="DatabaseName" />
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">select cast(serverproperty('EngineEdition') as int)</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.02-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="11" name="RPC:Starting">
          <Column id="1" name="TextData">exec sp_reset_connection</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">sp_reset_connection</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.22-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:58.673-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010001000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.21-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">
    SELECT Count(*)
    FROM INFORMATION_SCHEMA.TABLES AS t
    WHERE t.TABLE_SCHEMA + '.' + t.TABLE_NAME IN ('dbo.Employee','dbo.EmployeeTrade','dbo.TradeClass','dbo.Profession','dbo.TradeLevel','dbo.TradeProfession')
        OR t.TABLE_NAME = 'EdmMetadata'</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.22-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="11" name="RPC:Starting">
          <Column id="1" name="TextData">exec sp_reset_connection</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">sp_reset_connection</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.407-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.21-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010001000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.4-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="11" name="RPC:Starting">
          <Column id="1" name="TextData">exec sp_executesql N'SELECT 
        [GroupBy1].[A1] AS [C1]
        FROM ( SELECT 
            COUNT(1) AS [A1]
            FROM [dbo].[__MigrationHistory] AS [Extent1]
            WHERE [Extent1].[ContextKey] = @p__linq__0
        )  AS [GroupBy1]',N'@p__linq__0 nvarchar(4000)',@p__linq__0=N'StoredProceduresTesting.Models.EmployeeModel'</Column>
          <Column id="2" name="BinaryData">00000000030000001A00730070005F006500780065006300750074006500730071006C00CC01000082001A00E7206E00760061007200630068006100720028003200310030002900A4010000530045004C0045004300540020000D000A0020002000200020005B00470072006F00750070004200790031005D002E005B00410031005D0020004100530020005B00430031005D000D000A002000200020002000460052004F004D00200028002000530045004C0045004300540020000D000A002000200020002000200020002000200043004F0055004E00540028003100290020004100530020005B00410031005D000D000A0020002000200020002000200020002000460052004F004D0020005B00640062006F005D002E005B005F005F004D006900670072006100740069006F006E0048006900730074006F00720079005D0020004100530020005B0045007800740065006E00740031005D000D000A00200020002000200020002000200020005700480045005200450020005B0045007800740065006E00740031005D002E005B0043006F006E0074006500780074004B00650079005D0020003D002000400070005F005F006C0069006E0071005F005F0030000D000A0020002000200020002900200020004100530020005B00470072006F00750070004200790031005D005A00000082001800E7206E007600610072006300680061007200280032003600290034000000400070005F005F006C0069006E0071005F005F00300020006E0076006100720063006800610072002800340030003000300029009A00000082001C00E7306E0076006100720063006800610072002800340030003000300029001600400070005F005F006C0069006E0071005F005F00300058000000530074006F00720065006400500072006F006300650064007500720065007300540065007300740069006E0067002E004D006F00640065006C0073002E0045006D0070006C006F007900650065004D006F00640065006C00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">sp_executesql</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.407-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">SELECT 
        [GroupBy1].[A1] AS [C1]
        FROM ( SELECT 
            COUNT(1) AS [A1]
            FROM [dbo].[__MigrationHistory] AS [Extent1]
            WHERE [Extent1].[ContextKey] = @p__linq__0
        )  AS [GroupBy1]</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.407-04:00</Column>
          <Column id="22" name="ObjectID">357830368</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="11" name="RPC:Starting">
          <Column id="1" name="TextData">exec sp_reset_connection</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">sp_reset_connection</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:00.327-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:59.4-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010001000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:00.327-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">SELECT 
        [GroupBy1].[A1] AS [C1]
        FROM ( SELECT 
            COUNT(1) AS [A1]
            FROM [dbo].[__MigrationHistory] AS [Extent1]
        )  AS [GroupBy1]</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:00.327-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="11" name="RPC:Starting">
          <Column id="1" name="TextData">exec sp_reset_connection</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">sp_reset_connection</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:01.22-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:00.327-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010001000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:01.223-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">SELECT TOP (1) 
        [Extent1].[Id] AS [Id], 
        [Extent1].[ModelHash] AS [ModelHash]
        FROM [dbo].[EdmMetadata] AS [Extent1]
        ORDER BY [Extent1].[Id] DESC</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:01.22-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="11" name="RPC:Starting">
          <Column id="1" name="TextData">exec sp_reset_connection</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">sp_reset_connection</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:02.107-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:01.223-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010001000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:02.11-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">SELECT 
        [Extent1].[Profession_ID] AS [Profession_ID], 
        [Extent1].[Profession_Name] AS [Profession_Name]
        FROM [dbo].[Profession] AS [Extent1]</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:02.107-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="11" name="RPC:Starting">
          <Column id="1" name="TextData">exec sp_reset_connection</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">sp_reset_connection</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.19-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="3" name="DatabaseID" />
          <Column id="11" name="LoginName" />
          <Column id="35" name="DatabaseName" />
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:58.673-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="3" name="DatabaseID" />
          <Column id="11" name="LoginName" />
          <Column id="35" name="DatabaseName" />
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010001000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.193-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="11" name="RPC:Starting">
          <Column id="1" name="TextData">exec [dbo].[InsertEmployee] @Emp_First_Name='Jason',@Emp_Last_Name='Johns',@Emp_Gender='Male',@Profession_Profession_ID=5</Column>
          <Column id="2" name="BinaryData">00000000040000002C005B00640062006F005D002E005B0049006E00730065007200740045006D0070006C006F007900650065005D004900000081001600A730760061007200630068006100720028003200300029001E00400045006D0070005F00460069007200730074005F004E0061006D006500050000004A61736F6E4700000081001600A730760061007200630068006100720028003200300029001C00400045006D0070005F004C006100730074005F004E0061006D006500050000004A6F686E733E00000081001400A73076006100720063006800610072002800370029001600400045006D0070005F00470065006E00640065007200040000004D616C654800000003000600381069006E00740032004000500072006F00660065007300730069006F006E005F00500072006F00660065007300730069006F006E005F004900440005000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="42" name="SP:Starting">
          <Column id="1" name="TextData">exec [dbo].[InsertEmployee] @Emp_First_Name='Jason',@Emp_Last_Name='Johns',@Emp_Gender='Male',@Profession_Profession_ID=5</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="2" name="BinaryData" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">BEGIN TRY
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">SET TRANSACTION ISOLATION LEVEL SNAPSHOT
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">BEGIN TRANSACTION
    	-- SET NOCOUNT ON added to prevent extra result sets from
    	-- interfering with SELECT statements.
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">SET NOCOUNT ON;
    
        -- Insert statements for procedure here
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">SELECT @Emp_ID = IDENT_CURRENT( N'Employee' ) + 1</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">INSERT INTO Employee(  -- Inserts into Employee all releavant info 
    	Emp_First_Name,
    	Emp_Last_Name,
    	Emp_Gender,
    	Profession_Profession_ID )
    	VALUES (
    	@Emp_First_Name,
    	@Emp_Last_Name,
    	@Emp_Gender,
    	@Profession_Profession_ID )</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">BEGIN CATCH
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">THROW;
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="43" name="SP:Completed">
          <Column id="1" name="TextData">exec [dbo].[InsertEmployee] @Emp_First_Name='Jason',@Emp_Last_Name='Johns',@Emp_Gender='Male',@Profession_Profession_ID=5</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:46:13.2-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="2" name="BinaryData" />
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="12" name="SPID">59</Column>
          <Column id="14" name="StartTime">2015-08-25T17:45:58.673-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="35" name="DatabaseName" />
        </Event>
      </Events>
    </TraceData>

    2015-08-25T17:45:59.21-04:00 is where the page loaded.  I then typed in the information and hit create, which was at 2015-08-25T17:46:13.193-04:00.

    From SSMS:

    <?xml version="1.0" encoding="utf-16"?>
    <TraceData xmlns="http://tempuri.org/TracePersistence.xsd">
      <Header>
        <TraceProvider name="Microsoft SQL Server" MajorVersion="12" MinorVersion="0" BuildNumber="4213" />
        <ServerInformation name="MRM2SQL\MRM2SQLS2" />
        <ProfilerUI>
          <OrderedColumns>
            <ID>27</ID>
            <ID>1</ID>
            <ID>3</ID>
            <ID>35</ID>
            <ID>22</ID>
            <ID>34</ID>
            <ID>26</ID>
            <ID>2</ID>
            <ID>12</ID>
            <ID>14</ID>
            <ID>49</ID>
            <ID>11</ID>
          </OrderedColumns>
          <TracedEvents>
            <Event id="14">
              <EventColumn id="1" />
              <EventColumn id="2" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="35" />
            </Event>
            <Event id="15">
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="35" />
            </Event>
            <Event id="17">
              <EventColumn id="1" />
              <EventColumn id="2" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="35" />
            </Event>
            <Event id="11">
              <EventColumn id="1" />
              <EventColumn id="2" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="34" />
              <EventColumn id="35" />
            </Event>
            <Event id="43">
              <EventColumn id="1" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="22" />
              <EventColumn id="26" />
              <EventColumn id="34" />
              <EventColumn id="35" />
            </Event>
            <Event id="42">
              <EventColumn id="1" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="22" />
              <EventColumn id="26" />
              <EventColumn id="34" />
              <EventColumn id="35" />
            </Event>
            <Event id="44">
              <EventColumn id="1" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="22" />
              <EventColumn id="26" />
              <EventColumn id="34" />
              <EventColumn id="35" />
            </Event>
            <Event id="13">
              <EventColumn id="1" />
              <EventColumn id="3" />
              <EventColumn id="12" />
              <EventColumn id="14" />
              <EventColumn id="26" />
              <EventColumn id="35" />
            </Event>
          </TracedEvents>
        </ProfilerUI>
      </Header>
      <Events>
        <Event id="65534" name="Trace Start">
          <Column id="14" name="StartTime">2015-08-25T17:51:08.753-04:00</Column>
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">2000002838F4010000000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">54</Column>
          <Column id="14" name="StartTime">2015-08-25T14:21:08.123-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort on
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">6008002838F4050000000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">58</Column>
          <Column id="14" name="StartTime">2015-08-25T17:43:09.647-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort on
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">6008002838F4050000000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">61</Column>
          <Column id="14" name="StartTime">2015-08-25T17:43:14.72-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="17" name="ExistingConnection">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort on
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="2" name="BinaryData">6008002838F4050000000000</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:41:14.3-04:00</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">USE [EMPDB2]
    </Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.797-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">
    DECLARE	@return_value int
    
    EXEC	@return_value = [dbo].[InsertEmployee]
    		@Emp_First_Name = N'Jason',
    		@Emp_Last_Name = N'Johns',
    		@Emp_Gender = N'Male',
    		@Profession_Profession_ID = 5
    
    SELECT	'Return Value' = @return_value
    
    </Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.8-04:00</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="42" name="SP:Starting">
          <Column id="1" name="TextData">EXEC	@return_value = [dbo].[InsertEmployee]
    		@Emp_First_Name = N'Jason',
    		@Emp_Last_Name = N'Johns',
    		@Emp_Gender = N'Male',
    		@Profession_Profession_ID = 5
    
    </Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.843-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="2" name="BinaryData" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">BEGIN TRY
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.843-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">SET TRANSACTION ISOLATION LEVEL SNAPSHOT
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.843-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">BEGIN TRANSACTION
    	-- SET NOCOUNT ON added to prevent extra result sets from
    	-- interfering with SELECT statements.
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.843-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">SET NOCOUNT ON;
    
        -- Insert statements for procedure here
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.843-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">SELECT @Emp_ID = IDENT_CURRENT( N'Employee' ) + 1</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.843-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">INSERT INTO Employee(  -- Inserts into Employee all releavant info 
    	Emp_First_Name,
    	Emp_Last_Name,
    	Emp_Gender,
    	Profession_Profession_ID )
    	VALUES (
    	@Emp_First_Name,
    	@Emp_Last_Name,
    	@Emp_Gender,
    	@Profession_Profession_ID )</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.843-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="42" name="SP:Starting">
          <Column id="1" name="TextData">INSERT INTO Employee(  -- Inserts into Employee all releavant info 
    	Emp_First_Name,
    	Emp_Last_Name,
    	Emp_Gender,
    	Profession_Profession_ID )
    	VALUES (
    	@Emp_First_Name,
    	@Emp_Last_Name,
    	@Emp_Gender,
    	@Profession_Profession_ID )</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.847-04:00</Column>
          <Column id="22" name="ObjectID">309576141</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">Employee_Insert</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="2" name="BinaryData" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">INSERT INTO dbo.Employee_Audit
    SELECT *, 'New', 'Insert', SUSER_SNAME(),GETDATE() FROM INSERTED</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.847-04:00</Column>
          <Column id="22" name="ObjectID">309576141</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">Employee_Insert</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="43" name="SP:Completed">
          <Column id="1" name="TextData">INSERT INTO Employee(  -- Inserts into Employee all releavant info 
    	Emp_First_Name,
    	Emp_Last_Name,
    	Emp_Gender,
    	Profession_Profession_ID )
    	VALUES (
    	@Emp_First_Name,
    	@Emp_Last_Name,
    	@Emp_Gender,
    	@Profession_Profession_ID )</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.847-04:00</Column>
          <Column id="22" name="ObjectID">309576141</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">Employee_Insert</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="2" name="BinaryData" />
        </Event>
        <Event id="42" name="SP:Starting">
          <Column id="1" name="TextData">INSERT INTO Employee(  -- Inserts into Employee all releavant info 
    	Emp_First_Name,
    	Emp_Last_Name,
    	Emp_Gender,
    	Profession_Profession_ID )
    	VALUES (
    	@Emp_First_Name,
    	@Emp_Last_Name,
    	@Emp_Gender,
    	@Profession_Profession_ID )</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.847-04:00</Column>
          <Column id="22" name="ObjectID">325576198</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">Employee_Delete</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="2" name="BinaryData" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">INSERT INTO dbo.Employee_Audit
    SELECT *, 'Old', 'Delete', SUSER_SNAME(),GETDATE() FROM DELETED</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.847-04:00</Column>
          <Column id="22" name="ObjectID">325576198</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">Employee_Delete</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="43" name="SP:Completed">
          <Column id="1" name="TextData">INSERT INTO Employee(  -- Inserts into Employee all releavant info 
    	Emp_First_Name,
    	Emp_Last_Name,
    	Emp_Gender,
    	Profession_Profession_ID )
    	VALUES (
    	@Emp_First_Name,
    	@Emp_Last_Name,
    	@Emp_Gender,
    	@Profession_Profession_ID )</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.847-04:00</Column>
          <Column id="22" name="ObjectID">325576198</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">Employee_Delete</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="2" name="BinaryData" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">CREATE TABLE #TempTrade ( idx int PRIMARY KEY IDENTITY( 1,1 ), Emp_ID int, Trade_ID int, Trade_Level_ID int, Level_Mastery int )  -- Creates the temporary table
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.847-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">INSERT INTO #TempTrade ( Trade_ID ) -- inserts the Trades that relate to the profession into that table
    		SELECT TradeClass_Trade_Class_ID
    		FROM TradeProfession
    		WHERE Profession_Profession_ID = @Profession_Profession_ID</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.85-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">UPDATE #TempTrade -- adds Empacter_ID, Trade_Level Apprentice, and No Mastery to all rows
    	SET Emp_ID = @Emp_ID,
    		Trade_Level_ID = 1,
    		Level_Mastery = 0</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.85-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">INSERT INTO EmployeeTrade(
    		Employee_Emp_ID,
    		TradeClass_Trade_Class_ID,
    		TradeLevel_Trade_Level_ID,
    		Trade_Level_Mastery)
    	SELECT Emp_ID, Trade_ID, Trade_Level_ID, Level_Mastery FROM #TempTrade</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.85-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">DROP TABLE #TempTrade  -- drops the temp table..... THIS IS EXTREMELY IMPORTANT!!!!
    	</Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.85-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">COMMIT TRANSACTION
    </Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.85-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="44" name="SP:StmtStarting">
          <Column id="1" name="TextData">END TRY
    </Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.86-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
        </Event>
        <Event id="43" name="SP:Completed">
          <Column id="1" name="TextData">EXEC	@return_value = [dbo].[InsertEmployee]
    		@Emp_First_Name = N'Jason',
    		@Emp_Last_Name = N'Johns',
    		@Emp_Gender = N'Male',
    		@Profession_Profession_ID = 5
    
    </Column>
          <Column id="3" name="DatabaseID">9</Column>
          <Column id="35" name="DatabaseName">EMPDB2</Column>
          <Column id="12" name="SPID">62</Column>
          <Column id="14" name="StartTime">2015-08-25T17:51:56.843-04:00</Column>
          <Column id="22" name="ObjectID">805577908</Column>
          <Column id="26" name="ServerName">MRM2SQL\MRM2SQLS2</Column>
          <Column id="34" name="ObjectName">InsertEmployee</Column>
          <Column id="49" name="RequestID" />
          <Column id="11" name="LoginName" />
          <Column id="2" name="BinaryData" />
        </Event>
        <Event id="65533" name="Trace Stop">
          <Column id="14" name="StartTime">2015-08-25T17:52:10.987-04:00</Column>
        </Event>
      </Events>
    </TraceData>

    I hit Execute in SSMS at 2015-08-25T17:41:14.3-04:00.  If you look just prior in  both XML files you will see set transaction isolation level read committed, though one changes the isolation level and the other errors.  So I am baffled by this.  Still looking for help with this, if anyone sees what I am missing please let me know.

    Tuesday, August 25, 2015 6:50 PM