Database Reference
In-Depth Information
To identify the error conditions caused by database requests, you will need to include the following in your
Extended Events session (alternatively, you can create a new session that looks for these events in the errors or
warnings category):
error_reported
execution_warning
hash_warning
missing_column_statistics
missing_join_predicate
sort_warning
For example, consider the following SQL queries:
INSERT INTO Purchasing.PurchaseOrderDetail
(PurchaseOrderID,
DueDate,
OrderQty,
ProductID,
UnitPrice,
ReceivedQty,
RejectedQty,
ModifiedDate
)
VALUES (1066,
'1/1/2009',
1,
42,
98.6,
5,
4,
'1/1/2009'
) ;
GO
SELECT p.[Name],
psc.[Name]
FROM Production.Product AS p,
Production.ProductSubCategory AS psc ;
GO
Figure 25-14 shows the corresponding session output.
 
Search WWH ::




Custom Search