spGetDataSources

Definition

Copy


            CREATE PROCEDURE [dbo].[spGetDataSources]
            AS
            SELECT 
                DataSourceID, 
                [Name], 
                TypeNamespace,
                TypeName, 
                IsEmailListSource, 
                BackOfficeSystemId, 
                Available,
                ImportListID
                FROM [dbo].[DataSources]
                WHERE Deleted = 0
            ORDER BY BackOfficeSystemId, [Name]