Issue Element (ssbdiagnose)
Applies to: SQL Server
Reports an issue that was found by the ssbdiagnose utility. The ssbdiagnose XML output file has one Issue element per issue reported.
Syntax
<Issue
type="..."
code="..."
server="..."
database="..."
object="...">
...
</Issue>
Element Attributes
Attribute | Description |
---|---|
type | Identifies which category of problem the Issue element is reporting: "Diagnosis" Reports a configuration issue found when you analyze a Service Broker configuration. "Problem" Reports an issue that has prevented ssbdiagnose from completing its analysis. Correct the problem and rerun ssbdiagnose. "Event" Reports a SQL Server Profiler event found when you run a -RUNTIME check. Events are only reported if -SHOWEVENTS is specified. |
code | Identifies the error number for the message. |
server | Identifies the instance of the Database Engine in which the problem was found. If the problem was in a default instance, the server attribute only has the computer name. If the problem was in a named instance, the server attribute is in the form ComputerName\InstanceName. |
database | Identifies the name of the database in which the problem was found. |
object | Identifies the name of the object in which the problem was found. If the problem was an instance or database level issue, the object attribute repeats the instance or database name. |
Element Characteristics
Characteristic | Description |
---|---|
Data type and length | string, length is unlimited. |
Value | Returns the text of the error message. |
Occurrence | Once per reported error. |
Element Relationships
Relationship | Elements |
---|---|
Parent element | DiagnosticInformation Element (ssbdiagnose) |
Child elements | None |
Example
This element reports an 1102 error for a database that does not have a master key, where the error was found when you analyzed a Service Broker configuration.
<Issue type="Diagnosis" code="1102" server="TestComputer" database="TargetDB" object="TargetDB">The master key was not found</diagnostic>
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for