SCRS_GetProgramName Stored Procedure

In SCRM 2006, SCRS_GetProgramName gets the list of names of programs associated with a specified company.

SCRS_GetProgramName @LocaleID
,[ @Company = ] '<ALL>'

Arguments

*@LocaleID*

Type: int

Locale identifier for the installed product.

*@Company*

Type: nvarchar

Value for conditioning query against SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserPublisher.

Return Code

Type: int

Value: Always 0.

Result Sets

Column name Data Type Description

ProgramName

String

Output value from SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserDisplayName.

ProgramNameLabel

String

Output value from SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View.ARPUserDisplayName.

See Also

Other Resources

Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures