Compartir a través de


SQLServer Object

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

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

Modelo de objeto SQL-DMO con el objeto actual

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

 

Notas

The SQLServer object contains the objects and collections that implement SQL Server administrative tasks for SQL Distributed Management Objects (SQL-DMO). The object enables 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.

[!NOTA] The SQLServer object is compatible with instances of SQL Server versions 7.0 and later. However, the SQLServer2 object extends the functionality of the SQLServer object for use with features that were introduced in SQL Server 2000.

Vea también

Referencia

SQLServer2 Object

Ayuda e información

Obtener ayuda sobre SQL Server 2005