Name Property (SQL-DMO)

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

Applies To

Alert Object	MergeArticle 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
Linked Server Object	User Object
LogFile Object	UserDefinedDatatype Object
Login Object	View Object

Syntax

object.Name [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	String

Remarks

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

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetName(SQLDMO_LPBSTR pRetVal);

HRESULT SetName(SQLDMO_LPCSTR NewValue);

Note 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 by using SysFreeString.