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.