spGet_ClientSSO

            CREATE procedure dbo.spGet_ClientSSO
                @ClientSiteID int
            as
                set nocount on;
                set transaction isolation level read committed;
                begin
                    begin try
                        exec dbo.USP_GET_KEY_ACCESS
                        select
                            ID,
                            Description,
                            convert(nvarchar(512),DECRYPTBYKEY(SharedKey)) as SharedKey,
                            UserNameParameter,
                            TimeParameter,
                            MD5Parameter,
                            ClientSiteID,
                            Delta,
                            IncludeIP,
                            RequireSsl
                        from
                            dbo.ClientSSO
                        where
                            ClientSiteID = @ClientSiteID;
                        close symmetric key sym_BBInfinity
                    end try
                    begin catch
                        close symmetric key sym_BBInfinity
                    end catch
            end