There is also a problem with the msdb.dbo.sysschedules table that doesn't exist

I get an "Incorrect syntax near '='." when executing the script

It looks like the problem is located in the @numdays=DATEDIFF.... part but can figure out the solution

SELECT @startdate = DATEADD(dd,...

Thanks Jurgen.

But if I'm not wrong this command will script the roles : sp_addrole.....

The kind of script I would like to obtain would look like :

if not exists (select...

Thanks already for the answer received but I forgot to mention one important point : It' must be runnable on SQL 7.0 1 SQL 2000 (So bigint can't be used...)

...