• Thanks for your reply. Just extend the edition check to:

    /*

    Snapshots are only supported on Developer and Enterprise editions

    */

    if CAST(serverproperty('Edition') AS VARCHAR) not like 'Enterprise%'

    and CAST(serverproperty('Edition') AS VARCHAR) not like 'Developer%'

    begin

    if @verbose = 1

    raiserror('This SQL Server edition does not support snapshots',10,1)

    return 1

    end

    (I'll post an updated version later)

    I don't know why the registry check isn't working on your server. Do you have a different instancename? Have you checked your registry?

    Wilfred
    The best things in life are the simple things