Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <!--
- Filename: NullGuidError.xml
- -->
- <!--
- This file relates to the following DBA.StackExchange answer:
- http://dba.stackexchange.com/questions/147039/why-is-this-explicit-cast-causing-problems/147603#147603
- -->
- <TraceData xmlns="http://tempuri.org/TracePersistence.xsd">
- <Header>
- <TraceProvider name="Microsoft SQL Server" MajorVersion="11" MinorVersion="0" BuildNumber="6020" />
- <ServerInformation name="DALI" />
- <ProfilerUI>
- <OrderedColumns>
- <ID>27</ID>
- <ID>1</ID>
- <ID>10</ID>
- <ID>12</ID>
- </OrderedColumns>
- <TracedEvents>
- <Event id="16">
- <EventColumn id="12" />
- <EventColumn id="10" />
- </Event>
- <Event id="33">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="67">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="162">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="119">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="121">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="61">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="194">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="120">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="72">
- <EventColumn id="12" />
- <EventColumn id="10" />
- </Event>
- <Event id="71">
- <EventColumn id="12" />
- <EventColumn id="10" />
- </Event>
- <Event id="12">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="13">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="41">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="40">
- <EventColumn id="1" />
- <EventColumn id="10" />
- <EventColumn id="12" />
- </Event>
- <Event id="73">
- <EventColumn id="12" />
- <EventColumn id="10" />
- </Event>
- </TracedEvents>
- </ProfilerUI>
- </Header>
- <Events>
- <Event id="65534" name="Trace Start">
- <Column id="14" name="StartTime">2016-08-25T21:54:43.38-04:00</Column>
- </Event>
- <Event id="13" name="SQL:BatchStarting">
- <Column id="1" name="TextData">SELECT TOP (2) CAST(NULL AS UNIQUEIDENTIFIER) AS [Something]--, (SELECT COUNT(*) FROM sys.[data_spaces]) AS [lcl]
- FROM [Local].[TEMPTEST].[sys].[objects] rmt
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="40" name="SQL:StmtStarting">
- <Column id="1" name="TextData">SELECT TOP (2) CAST(NULL AS UNIQUEIDENTIFIER) AS [Something]--, (SELECT COUNT(*) FROM sys.[data_spaces]) AS [lcl]
- FROM [Local].[TEMPTEST].[sys].[objects] rmt
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IGetDataSource</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA563318</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IUnknown</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppDataSource>0x00000001CAFD0340</ppDataSource>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IDBProperties</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001C34440C0</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cPropertyIDSets>1</cPropertyIDSets>
- <rgPropertyIDSets>
- <DBPROPIDSET>
- <cPropertyIDs>1</cPropertyIDs>
- <rgPropertyIDs>
- <DBPROPID>DBPROP_CONNECTIONSTATUS</DBPROPID>
- </rgPropertyIDs>
- <guidPropertySet>DBPROPSET_DATASOURCEINFO</guidPropertySet>
- </DBPROPIDSET>
- </rgPropertyIDSets>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcPropertySets>1</pcPropertySets>
- <prgPropertySets>
- <DBPROPSET>
- <cProperties>1</cProperties>
- <guidPropertySet>DBPROPSET_DATASOURCEINFO</guidPropertySet>
- <rgProperties>
- <DBPROP>
- <dwPropertyID>DBPROP_CONNECTIONSTATUS</dwPropertyID>
- <dwOptions>0</dwOptions>
- <dwStatus>0</dwStatus>
- <colid>DB_NULLID</colid>
- <vValue>
- <VARIANT>
- <vt>VT_I4</vt>
- <lVal>1</lVal>
- </VARIANT>
- </vValue>
- </DBPROP>
- </rgProperties>
- </DBPROPSET>
- </prgPropertySets>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IDBCreateCommand</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA5632B8</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <pUnkOuter>0x0000000000000000</pUnkOuter>
- <riid>IID_ICommandText</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppCommand>0x00000001CAFD0340</ppCommand>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <rguidDialect>{C8B521FB-5CF3-11CE-ADE5-00AA0044773D}</rguidDialect>
- <pwszCommand>SET XACT_ABORT OFF</pwszCommand>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_ICommandProperties</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA53A180</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cPropertySets>1</cPropertySets>
- <rgPropertySets>
- <DBPROPSET>
- <cProperties>1</cProperties>
- <guidPropertySet>DBPROPSET_ROWSET</guidPropertySet>
- <rgProperties>
- <DBPROP>
- <dwPropertyID>DBPROP_COMMANDTIMEOUT</dwPropertyID>
- <dwOptions>1</dwOptions>
- <dwStatus>0</dwStatus>
- <colid>DB_NULLID</colid>
- <vValue>
- <VARIANT>
- <vt>VT_I4</vt>
- <lVal>600</lVal>
- </VARIANT>
- </vValue>
- </DBPROP>
- </rgProperties>
- </DBPROPSET>
- </rgPropertySets>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <pUnkOuter>0x0000000000000000</pUnkOuter>
- <riid>IID_NULL</riid>
- <pParams>0x0000000000000000</pParams>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="13" name="SQL:BatchStarting">
- <Column id="1" name="TextData">SET XACT_ABORT OFF</Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server</Column>
- <Column id="12" name="SPID">59</Column>
- </Event>
- <Event id="40" name="SQL:StmtStarting">
- <Column id="1" name="TextData">SET XACT_ABORT OFF</Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server</Column>
- <Column id="12" name="SPID">59</Column>
- </Event>
- <Event id="41" name="SQL:StmtCompleted">
- <Column id="1" name="TextData">SET XACT_ABORT OFF</Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server</Column>
- <Column id="12" name="SPID">59</Column>
- </Event>
- <Event id="12" name="SQL:BatchCompleted">
- <Column id="1" name="TextData">SET XACT_ABORT OFF</Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server</Column>
- <Column id="12" name="SPID">59</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_ITransactionLocal</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA5632C8</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <isoLevel>4096</isoLevel>
- <isoFlags>0</isoFlags>
- <pOtherOptions>0x0000000000000000</pOtherOptions>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pulTransactionLevel>1</pulTransactionLevel>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="194" name="OLEDB Provider Information">
- <Column id="1" name="TextData"><ProviderInformation>
- <Provider>SQLNCLI11</Provider>
- <LinkedServer>Local</LinkedServer>
- <ProviderCapabilitiesAndSettings>
- <Ansi92EntrySupport>1</Ansi92EntrySupport>
- <ODBCCoreSupport>1</ODBCCoreSupport>
- <ODBCMinimumSupport>1</ODBCMinimumSupport>
- <SimpleGrammarSupport>0</SimpleGrammarSupport>
- <AnsiLikeSupport>0</AnsiLikeSupport>
- <SQLLikeSupport>0</SQLLikeSupport>
- <DateLiteralsSupport>1</DateLiteralsSupport>
- <GroupBySupport>0</GroupBySupport>
- <InnerJoinSupport>0</InnerJoinSupport>
- <SubqueriesSupport>0</SubqueriesSupport>
- <SimpleUpdatesSupport>0</SimpleUpdatesSupport>
- <HistogramsSupport>1</HistogramsSupport>
- <ColumnLevelCollationSupport>1</ColumnLevelCollationSupport>
- <ConnectionSharingSupport>1</ConnectionSharingSupport>
- <MultipleActiveRowsetsSupport>1</MultipleActiveRowsetsSupport>
- <MultipleResultsSupport>1</MultipleResultsSupport>
- <AllowLimitingRowsReturned>1</AllowLimitingRowsReturned>
- <NullConcatenationYieldsNull>1</NullConcatenationYieldsNull>
- <StructuredStorageAccessToLargeObjects>1</StructuredStorageAccessToLargeObjects>
- <MultipleConcurrentLargeObjectSupport>0</MultipleConcurrentLargeObjectSupport>
- <DynamicParametersSupport>1</DynamicParametersSupport>
- <NestedQueriesSupport>1</NestedQueriesSupport>
- <IndicesAvailableAsAccessPath>0</IndicesAvailableAsAccessPath>
- <AllowDataAccessByReference>1</AllowDataAccessByReference>
- <RowsetChangesAreVisible>1</RowsetChangesAreVisible>
- <RowsetSupportsAppendOnly>0</RowsetSupportsAppendOnly>
- <UseLevelZeroOledbInterfacesOnly>0</UseLevelZeroOledbInterfacesOnly>
- <RowsetUpdatability>1</RowsetUpdatability>
- <AsynchronousRowsetProcessingSupport>1</AsynchronousRowsetProcessingSupport>
- <DataSourceUnicodeLocaleId>0</DataSourceUnicodeLocaleId>
- <DataSourceUnicodeComparisonStyle>0</DataSourceUnicodeComparisonStyle>
- <DataSourceCollationComparisonFlags>0</DataSourceCollationComparisonFlags>
- <DataSourceCharacterset></DataSourceCharacterset>
- <DataSourceSortOrder></DataSourceSortOrder>
- <DataSourceNullCollationOrder>4</DataSourceNullCollationOrder>
- <CurrentDbCollationSameAsDefaultRemoteDbCollation>1</CurrentDbCollationSameAsDefaultRemoteDbCollation>
- <UnicodeLiteralSupport>1</UnicodeLiteralSupport>
- <UnicodeLiteralPrefix>N'</UnicodeLiteralPrefix>
- <UnicodeLiteralSuffix>'</UnicodeLiteralSuffix>
- <DateLiteralPrefix>'</DateLiteralPrefix>
- <DateLiteralSuffix>'</DateLiteralSuffix>
- <ObjectNameConstructionFlags>54</ObjectNameConstructionFlags>
- <SchemaSeparator>.</SchemaSeparator>
- <CatalogSeparator>.</CatalogSeparator>
- <QuoteSeparator>"</QuoteSeparator>
- <BitRemoting>0</BitRemoting>
- <UnicodeLiterals>1</UnicodeLiterals>
- <ProviderOledbVersion>131152</ProviderOledbVersion>
- <HalloweenProtectionNeeded>1</HalloweenProtectionNeeded>
- <RowsetUsableAcrossThreads>0</RowsetUsableAcrossThreads>
- <ObjectNameIsSinglePart>0</ObjectNameIsSinglePart>
- <ObjectVersion>181655659808373</ObjectVersion>
- <Cardinality>-1</Cardinality>
- <BookmarkSupport>1</BookmarkSupport>
- <BookmarksReusable>0</BookmarksReusable>
- <BookmarkType>Numeric</BookmarkType>
- <BookmarkDataType>21</BookmarkDataType>
- <BookmarkSize>8</BookmarkSize>
- <TableFlags>0</TableFlags>
- </ProviderCapabilitiesAndSettings>
- </ProviderInformation>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_ISchemaLock</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA563368</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IDBCreateCommand</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA5632B8</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <pUnkOuter>0x0000000000000000</pUnkOuter>
- <riid>IID_ICommandText</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppCommand>0x00000001CAFD0280</ppCommand>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <rguidDialect>{C8B521FB-5CF3-11CE-ADE5-00AA0044773D}</rguidDialect>
- <pwszCommand>SELECT TOP (2) NULL "Expr1002" FROM "TEMPTEST"."sys"."objects" "Tbl1001"</pwszCommand>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_ICommandProperties</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA53A180</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cPropertySets>1</cPropertySets>
- <rgPropertySets>
- <DBPROPSET>
- <cProperties>3</cProperties>
- <guidPropertySet>DBPROPSET_ROWSET</guidPropertySet>
- <rgProperties>
- <DBPROP>
- <dwPropertyID>DBPROP_COMMANDTIMEOUT</dwPropertyID>
- <dwOptions>1</dwOptions>
- <dwStatus>0</dwStatus>
- <colid>DB_NULLID</colid>
- <vValue>
- <VARIANT>
- <vt>VT_I4</vt>
- <lVal>600</lVal>
- </VARIANT>
- </vValue>
- </DBPROP>
- <DBPROP>
- <dwPropertyID>DBPROP_ISupportErrorInfo</dwPropertyID>
- <dwOptions>1</dwOptions>
- <dwStatus>0</dwStatus>
- <colid>DB_NULLID</colid>
- <vValue>
- <VARIANT>
- <vt>VT_BOOL</vt>
- <boolVal>-1</boolVal>
- </VARIANT>
- </vValue>
- </DBPROP>
- <DBPROP>
- <dwPropertyID>DBPROP_ROWSET_ASYNCH</dwPropertyID>
- <dwOptions>0</dwOptions>
- <dwStatus>0</dwStatus>
- <colid>DB_NULLID</colid>
- <vValue>
- <VARIANT>
- <vt>VT_I4</vt>
- <lVal>1</lVal>
- </VARIANT>
- </vValue>
- </DBPROP>
- </rgProperties>
- </DBPROPSET>
- </rgPropertySets>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IAccessor</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA53A078</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_ICommandPrepare</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA53A170</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cExpectedRuns>0</cExpectedRuns>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <pUnkOuter>0x0000000000000000</pUnkOuter>
- <riid>IID_IMultipleResults</riid>
- <pParams>0x0000000000000000</pParams>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="71" name="Prepare SQL">
- <Column id="10" name="ApplicationName">Microsoft SQL Server</Column>
- <Column id="12" name="SPID">59</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcRowsAffected>-1</pcRowsAffected>
- <ppRowset>0x00000001CAFD01C0</ppRowset>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IRowsetInfo</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="61" name="OLEDB Errors">
- <Column id="1" name="TextData"><hresult>-2147467262</hresult>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_ICommandProperties</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA53A180</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cPropertyIDSets>1</cPropertyIDSets>
- <rgPropertyIDSets>
- <DBPROPIDSET>
- <cPropertyIDs>1</cPropertyIDs>
- <rgPropertyIDs>
- <DBPROPID>DBPROP_MAXOPENROWS</DBPROPID>
- </rgPropertyIDs>
- <guidPropertySet>DBPROPSET_ROWSET</guidPropertySet>
- </DBPROPIDSET>
- </rgPropertyIDSets>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcPropertySets>1</pcPropertySets>
- <prgPropertySets>
- <DBPROPSET>
- <cProperties>1</cProperties>
- <guidPropertySet>DBPROPSET_ROWSET</guidPropertySet>
- <rgProperties>
- <DBPROP>
- <dwPropertyID>DBPROP_MAXOPENROWS</dwPropertyID>
- <dwOptions>0</dwOptions>
- <dwStatus>0</dwStatus>
- <colid>DB_NULLID</colid>
- <vValue>
- <VARIANT>
- <vt>VT_I4</vt>
- <lVal>0</lVal>
- </VARIANT>
- </vValue>
- </DBPROP>
- </rgProperties>
- </DBPROPSET>
- </prgPropertySets>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <pUnkOuter>0x0000000000000000</pUnkOuter>
- <lResultFlag>0</lResultFlag>
- <riid>IID_ISSAsynchStatus</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcRowsAffected>-1</pcRowsAffected>
- <ppRowset>0x00000001CAFD0100</ppRowset>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IRowset</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA50CC30</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IAccessor</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA50CB30</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IColumnsInfo</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA50CC40</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcColumns>1</pcColumns>
- <prgInfo>
- <DBCOLUMNINFO>
- <pwszName>Expr1002</pwszName>
- <pTypeInfo>0x0000000000000000</pTypeInfo>
- <iOrdinal>1</iOrdinal>
- <dwFlags>112</dwFlags>
- <ulColumnSize>4</ulColumnSize>
- <wType>3</wType>
- <bPrecision>10</bPrecision>
- <bScale>255</bScale>
- <DBID>
- <eKind>DBKIND_GUID_NAME</eKind>
- <uGuid.guid>{00000001-0000-0000-0000-000000000000}</uGuid.guid>
- <uName.pwszName>Expr1002</uName.pwszName>
- </DBID>
- </DBCOLUMNINFO>
- </prgInfo>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IRowsetInfo</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA50CC50</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cPropertyIDSets>1</cPropertyIDSets>
- <rgPropertyIDSets>
- <DBPROPIDSET>
- <cPropertyIDs>1</cPropertyIDs>
- <rgPropertyIDs>
- <DBPROPID>DBPROP_ISequentialStream</DBPROPID>
- </rgPropertyIDs>
- <guidPropertySet>DBPROPSET_ROWSET</guidPropertySet>
- </DBPROPIDSET>
- </rgPropertyIDSets>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcPropertySets>1</pcPropertySets>
- <prgPropertySets>
- <DBPROPSET>
- <cProperties>1</cProperties>
- <guidPropertySet>DBPROPSET_ROWSET</guidPropertySet>
- <rgProperties>
- <DBPROP>
- <dwPropertyID>DBPROP_ISequentialStream</dwPropertyID>
- <dwOptions>0</dwOptions>
- <dwStatus>0</dwStatus>
- <colid>DB_NULLID</colid>
- <vValue>
- <VARIANT>
- <vt>VT_BOOL</vt>
- <boolVal>-1</boolVal>
- </VARIANT>
- </vValue>
- </DBPROP>
- </rgProperties>
- </DBPROPSET>
- </prgPropertySets>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <dwAccessorFlags>2</dwAccessorFlags>
- <cBindings>1</cBindings>
- <rgBindings>
- <DBBINDING>
- <iOrdinal>1</iOrdinal>
- <obValue>16</obValue>
- <obLength>8</obLength>
- <obStatus>0</obStatus>
- <pTypeInfo>0x0000000000000000</pTypeInfo>
- <pObject>0x0000000000000000</pObject>
- <pBindExt>0x0000000000000000</pBindExt>
- <dwPart>5</dwPart>
- <dwMemOwner>0</dwMemOwner>
- <eParamIO>0</eParamIO>
- <cbMaxLen>16</cbMaxLen>
- <dwFlags>0</dwFlags>
- <wType>72</wType>
- <bPrecision>0</bPrecision>
- <bScale>0</bScale>
- </DBBINDING>
- </rgBindings>
- <cbRowSize>0</cbRowSize>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <phAccessor>0x0000000000000001</phAccessor>
- <rgStatus>
- <DBBINDSTATUS>0</DBBINDSTATUS>
- </rgStatus>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IColumnsInfo</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA50CC40</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcColumns>1</pcColumns>
- <prgInfo>
- <DBCOLUMNINFO>
- <pwszName>Expr1002</pwszName>
- <pTypeInfo>0x0000000000000000</pTypeInfo>
- <iOrdinal>1</iOrdinal>
- <dwFlags>112</dwFlags>
- <ulColumnSize>4</ulColumnSize>
- <wType>3</wType>
- <bPrecision>10</bPrecision>
- <bScale>255</bScale>
- <DBID>
- <eKind>DBKIND_GUID_NAME</eKind>
- <uGuid.guid>{00000001-0000-0000-0000-000000000000}</uGuid.guid>
- <uName.pwszName>Expr1002</uName.pwszName>
- </DBID>
- </DBCOLUMNINFO>
- </prgInfo>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IRowsetInfo</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA50CC50</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cPropertyIDSets>1</cPropertyIDSets>
- <rgPropertyIDSets>
- <DBPROPIDSET>
- <cPropertyIDs>1</cPropertyIDs>
- <rgPropertyIDs>
- <DBPROPID>DBPROP_ISequentialStream</DBPROPID>
- </rgPropertyIDs>
- <guidPropertySet>DBPROPSET_ROWSET</guidPropertySet>
- </DBPROPIDSET>
- </rgPropertyIDSets>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcPropertySets>1</pcPropertySets>
- <prgPropertySets>
- <DBPROPSET>
- <cProperties>1</cProperties>
- <guidPropertySet>DBPROPSET_ROWSET</guidPropertySet>
- <rgProperties>
- <DBPROP>
- <dwPropertyID>DBPROP_ISequentialStream</dwPropertyID>
- <dwOptions>0</dwOptions>
- <dwStatus>0</dwStatus>
- <colid>DB_NULLID</colid>
- <vValue>
- <VARIANT>
- <vt>VT_BOOL</vt>
- <boolVal>-1</boolVal>
- </VARIANT>
- </vValue>
- </DBPROP>
- </rgProperties>
- </DBPROPSET>
- </prgPropertySets>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <hReserved>0x0000000000000000</hReserved>
- <lRowsOffset>0</lRowsOffset>
- <cRows>1</cRows>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcRowsObtained>1</pcRowsObtained>
- <prghRows>
- <HROW>0x0000000000000001</HROW>
- </prghRows>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="121" name="OLEDB DataRead Event">
- <Column id="1" name="TextData"><inputs>
- <hRow>0x0000000000000001</hRow>
- <hAccessor>0x0000000000000001</hAccessor>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="61" name="OLEDB Errors">
- <Column id="1" name="TextData"><hresult>-2147217891</hresult>
- <inputs>
- <hRow>0x0000000000000001</hRow>
- <hAccessor>0x0000000000000001</hAccessor>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="121" name="OLEDB DataRead Event">
- <Column id="1" name="TextData"><hresult>-2147217891</hresult>
- <outputs>
- <pData>0x0000000010C1C6F0</pData>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_ISupportErrorInfo</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA5099C0</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IRowset</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="162" name="User Error Message">
- <Column id="1" name="TextData">OLE DB provider "SQLNCLI11" for linked server "Local" returned message "Requested conversion is not supported.".</Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="33" name="Exception">
- <Column id="1" name="TextData">Cannot get the current row value of column "(user generated expression).Expr1002" from OLE DB provider "SQLNCLI11" for linked server "Local". </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="162" name="User Error Message">
- <Column id="1" name="TextData">Cannot get the current row value of column "(user generated expression).Expr1002" from OLE DB provider "SQLNCLI11" for linked server "Local". </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <hAccessor>0x0000000000000001</hAccessor>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <pcRefCount>0</pcRefCount>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cRows>1</cRows>
- <rghRows>
- <HROW>0x0000000000000001</HROW>
- </rghRows>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="73" name="Unprepare SQL">
- <Column id="10" name="ApplicationName">Microsoft SQL Server</Column>
- <Column id="12" name="SPID">59</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <pboidReason>0</pboidReason>
- <fRetaining>0</fRetaining>
- <fAsync>0</fAsync>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IDBCreateCommand</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA5632B8</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <pUnkOuter>0x0000000000000000</pUnkOuter>
- <riid>IID_ICommandText</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppCommand>0x00000001CAFD0160</ppCommand>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <rguidDialect>{C8B521FB-5CF3-11CE-ADE5-00AA0044773D}</rguidDialect>
- <pwszCommand>{?=call sp_reset_connection}</pwszCommand>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_IAccessor</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA53A078</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><inputs>
- <riid>IID_ICommandWithParameters</riid>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="120" name="OLEDB QueryInterface Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <ppunk>0x00000001CA53A150</ppunk>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <cParams>1</cParams>
- <rgParamOrdinals>
- <DB_UPARAMS>1</DB_UPARAMS>
- </rgParamOrdinals>
- <rgParamBindInfo>
- <DBPARAMBINDINFO>
- <pwszDataSourceType>DBTYPE_I4</pwszDataSourceType>
- <pwszName>(null)</pwszName>
- <ulParamSize>4</ulParamSize>
- <dwFlags>2</dwFlags>
- <bPrecision>10</bPrecision>
- <bScale>0</bScale>
- </DBPARAMBINDINFO>
- </rgParamBindInfo>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>265922</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <dwAccessorFlags>4</dwAccessorFlags>
- <cBindings>1</cBindings>
- <rgBindings>
- <DBBINDING>
- <iOrdinal>1</iOrdinal>
- <obValue>16</obValue>
- <obLength>8</obLength>
- <obStatus>0</obStatus>
- <pTypeInfo>0x0000000000000000</pTypeInfo>
- <pObject>0x0000000000000000</pObject>
- <pBindExt>0x0000000000000000</pBindExt>
- <dwPart>5</dwPart>
- <dwMemOwner>0</dwMemOwner>
- <eParamIO>2</eParamIO>
- <cbMaxLen>4</cbMaxLen>
- <dwFlags>0</dwFlags>
- <wType>3</wType>
- <bPrecision>10</bPrecision>
- <bScale>0</bScale>
- </DBBINDING>
- </rgBindings>
- <cbRowSize>0</cbRowSize>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- <phAccessor>0x0000000000000001</phAccessor>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <pUnkOuter>0x0000000000000000</pUnkOuter>
- <riid>IID_NULL</riid>
- <pParams>
- <DBPARAMS>
- <pData>0x0000000010C15180</pData>
- <cParamSets>1</cParamSets>
- <hAccessor>0x0000000000000001</hAccessor>
- </DBPARAMS>
- </pParams>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><inputs>
- <hAccessor>0x0000000000000001</hAccessor>
- </inputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="119" name="OLEDB Call Event">
- <Column id="1" name="TextData"><hresult>0</hresult>
- <outputs>
- </outputs>
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="12" name="SQL:BatchCompleted">
- <Column id="1" name="TextData">SELECT TOP (2) CAST(NULL AS UNIQUEIDENTIFIER) AS [Something]--, (SELECT COUNT(*) FROM sys.[data_spaces]) AS [lcl]
- FROM [Local].[TEMPTEST].[sys].[objects] rmt
- </Column>
- <Column id="10" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
- <Column id="12" name="SPID">56</Column>
- </Event>
- <Event id="65533" name="Trace Stop">
- <Column id="14" name="StartTime">2016-08-25T21:54:50.42-04:00</Column>
- </Event>
- </Events>
- </TraceData>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement