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