You are designing a database that contains a data definition language (DDL) trigger. The DDL trigger will provide the maximum amount of data available when any attempt is made to change the database schema. You need to design a table to meet the following requirements:
* Accept the EVENTDATA information that is provided by the trigger
* Support the searching and retrieval of nodes and values
* Minimize development time
Which data type should you use?
A.
nvarchar(max)
B.
varchar(max)
C.
varbinary
D.
XML