SQLServer Object (SQL-DMO)

The SQLServer object exposes the attributes of a server running Microsoft® SQL Server™.

Remarks

The SQLServer object contains the objects and collections that implement SQL Server administrative tasks for SQL-DMO. The object allows SQL-DMO applications to connect to a server running SQL Server by name, establishing the context for administrative tasks.

With the SQLServer object, you can:

Connect to an existing server running SQL Server.
Query a server running SQL Server to determine its installed configuration and run-time parameters.
Add and remove SQL Server objects, such as backup devices, databases, and logins.
Execute Transact-SQL or operating system commands on the server.
Disable processes on a server running SQL Server.
Trap SQL Server events and SQLServer object events, providing status information to SQL-DMO application users or debugging information to SQL-DMO application developers.

Methods

AddStartParameter Method	ExecuteWithResults Method
AttachDB Method	ExecuteWithResultsAndMessages Method
AttachDBWithSingleFile Method	IsLogin Method
BeginTransaction Method	IsNTGroupMember Method
Close Method	IsOS Method
CommandShellImmediate Method	IsPackage Method
CommandShellWithResults Method	KillDatabase Method
CommitTransaction Method	KillProcess Method
Connect Method	ListMembers Method (SQLServer)
Continue Method	ListStartupProcedures Method
DetachDB Method	Pause Method
DisConnect Method	PingSQLServerVersion Method
EnumAccountInfo Method	ReadBackupHeader Method (SQLServer)
EnumAvailableMedia Method	ReadErrorLog Method
EnumDirectories Method	ReConnect Method
EnumErrorLogs Method	RollbackTransaction Method
EnumLocks Method	SaveTransaction Method
EnumLoginMappings Method	Shutdown Method
EnumNTDomainGroups Method	Start Method (SQLServer)
EnumProcesses Method	Stop Method
EnumServerAttributes Method	UnloadODSDLL Method
EnumVersionInfo Method	VerifyConnection Method
ExecuteImmediate Method (Database, SQLServer)

Events

CommandSent Event	RemoteLoginFailed Event
ConnectionBroken Event	ServerMessage Event
QueryTimeout Event

Properties

AnsiNulls Property	NetName Property
ApplicationName Property	NetPacketSize Property
AutoReConnect Property	NextDeviceNumber Property
BlockingTimeout Property	ODBCPrefix Property
CodePage Property	Password Property
CommandTerminator Property	ProcessID Property
ConnectionID Property	ProcessInputBuffer Property
EnableBcp Property	ProcessOutputBuffer Property
HostName Property	QueryTimeout Property
Isdbcreator Property	QuotedIdentifier Property
Isdiskadmin Property	RegionalSetting Property
Isprocessadmin Property	SaLogin Property
Issecurityadmin Property	Status Property (Services)
Isserveradmin Property	StatusInfoRefetchInterval Property
Issetupadmin Property	TranslateChar Property
Issysadmin Property	TrueLogin Property
Language Property	TrueName Property
Login Property	UserProfile Property
LoginSecure Property	VersionMajor Property
LoginTimeout Property	VersionMinor Property
MaxNumericPrecision Property	VersionString Property
Name Property