USP_INSTALLATIONINFO_GETLICENSEINFO

Retrieves the INSTALLATIONNAME, SERIALNUMBER, and CLARIFYSITEID values from the INSTALLATIONINFO table.

Definition



            CREATE procedure dbo.USP_INSTALLATIONINFO_GETLICENSEINFO
            with execute as caller
            as

                set NOCOUNT on;

                select INSTALLATIONNAME, SERIALNUMBER, CLARIFYSITEID, PRODUCT, ENVIRONMENTID
                from dbo.INSTALLATIONINFO
                where [ID] = 1;

            return 0;