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 Nameproperty, 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