[dbo].[MssWebGetAccountProfileServiceStatuses]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebGetAccountProfileServiceStatuses

Properties
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

CREATE PROCEDURE [dbo].[MssWebGetAccountProfileServiceStatuses]
AS
SELECT
    [Key] = AccountProfileServiceStatusID,
    [Value] = Name
FROM
    AccountProfileServiceStatus
ORDER BY Name
GO
GRANT EXECUTE ON  [dbo].[MssWebGetAccountProfileServiceStatuses] TO [MssExec]
GO

Uses

[dbo].[AccountProfileServiceStatus]
dbo