SQLServer Object

SQL-DMO

SQLServer Object

The SQLServer object exposes the attributes of an instance of Microsoft® SQL Server™.

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

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

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 an instance of SQL Server by name, establishing the context for administrative tasks.

With the SQLServer object, you can:

Connect to an instance of SQL Server.
Query an instance of 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 an instance of 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.

Note The SQLServer object is compatible with instances of SQL Server 2000 and SQL Server version 7.0. However, the SQLServer2 object extends the functionality of the SQLServer object for use with features that are new in SQL Server 2000.