• KlK,

    The reason for this is Money.

    Server 1. Just doesnt need Enterprise edition.

    Server 2. Now has an instance that is used on the web and also doesnt need Enterprise edition, but needs 2 processor licenses (diff. £30000).

    Licenses were bought but the company split in 2 so these original licenses have gone.

    Hence me having to downgrade them.

    I presumed

    1. Backup Master

    2. Uninstall SQL Enterprise

    3. Install SQL Standard

    4. Restore master

    would probably do it.

     

    Many thanks for your replies

    Bill Devonshire