This topic has not yet been rated - Rate this topic

ResultInfo Class

SQL Server 2012

Represents the results from executing a Transact-SQL batch.

System.Object
Microsoft.SqlServer.Management.MultiServerConnection.ResultInfo
Microsoft.SqlServer.Management.MultiServerConnection.NonQueryResult

Namespace: Microsoft.SqlServer.Management.MultiServerConnection
Assembly: Microsoft.SqlServer.Management.MultiServerConnection (in Microsoft.SqlServer.Management.MultiServerConnection.dll)

public class ResultInfo : IResultInfo

The ResultInfo type exposes the following members.

	Name	Description
	ResultInfo(IResultInfo)	Initializes a new instance of the ResultInfo class that is a copy of the specified ResultInfo object.
	ResultInfo(MultiServerSqlConnectionInfo, String, Int32)	Initializes a new instance of the ResultInfo class by using the specified connection information, text, and starting line number.

	Name	Description
	BatchStartingLine	Gets the starting line of the batch in the editor.
	BatchText	Gets the text of the Transact-SQL batch that was executed.
	CompletedSuccessfully	Gets True if execution was successful, False if there was an exception.
	ConnectionInfo	Gets the connection info of the connection producing the result.
	Exception	Gets or sets the exception that was thrown while executing the Transact-SQL.
	ExecutionTime	Gets or sets the amount of client wall-time it took to get the result back from the server.
	LoginName	Gets the name of the login executing the batch.
	ServerDisplayName	Gets the display name of the server where the batch was executed.
	ServerName	Gets the name of the server where the batch was executed.
	StartTime	Gets or sets the time when the batch was submitted.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions