USP_OLAPDATASOURCE_GETSERVERDATABASE

Parameters

Parameter Parameter Type Mode Description
@MARTKEY nvarchar(255) IN

Definition

Copy


CREATE procedure dbo.USP_OLAPDATASOURCE_GETSERVERDATABASE(@MARTKEY nvarchar(255))
as begin

  set nocount on;

  select 
    [ETLSERVERNAME], 
    [ETLDATABASENAME],
    [ID] as [OLAPDATASOURCEID]
  from dbo.[OLAPDATASOURCE] 
  where [MARTKEY] = @MARTKEY;

  return 0;

end