Name Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The Name property is a character string identifying a Microsoft SQL Server database, SQL Server Agent, or a replication object.

Syntax

object
.Name [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list
  • value
    A string

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetName(SQLDMO_LPBSTR pRetVal);
HRESULT SetName(SQLDMO_LPCSTR NewValue);

Note

SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Remarks

For restrictions on modifiability and content of the Name property, see the documentation for the applicable object.

Applies To:

Alert Object

MergeDynamicSnapshotJob Object

Application Object

MergePublication Object

BackupDevice Object

MergePullSubscription Object

Category Object

MergeSubscription Object

Check Object

MergeSubsetFilter Object

Column Object

Operator Object

ConfigValue Object

Property Object

Database Object

RemoteServer Object

DatabaseRole Object

RegisteredServer Object

DBFile Object

RegisteredSubscriber Object

DBObject Object

ReplicationDatabase Object

Default Object

ReplicationStoredProcedure Object

DistributionArticle Object

ReplicationTable Object

DistributionDatabase Object

Rule Object

DistributionPublication Object

ServerRole Object

DistributionPublisher Object

ServerGroup Object

DistributionSubscription Object

SQLServer Object

DRIDefault Object

StoredProcedure Object

FileGroup Object

SystemDatatype Object

FullTextCatalog Object

Table Object

Index Object

TargetServerGroup Object

Job Object

TransArticle Object

JobSchedule Object

TransPublication Object

JobStep Object

TransPullSubscription Object

Key Object

TransSubscription Object

Language Object

Trigger Object

LinkedServer Object

User Object

LogFile Object

UserDefinedDatatype Object

Login Object

UserDefinedFunction Object

MergeArticle Object

View Object