To make SQL to generate the scripts according to the
version we want..
I came across the following problem:·
I generated a script for a SQL 2005 job from SQL Server
Management Studio 2008·
When running that script on another SQL 2005 I got the
following error:@schedule_uid is not a parameter for procedure
sp_add_jobschedule. Getting through this, I found out that the error is due
to SSMS 2008 generates scripts for 2008 by default, hence,
not taking into account the engine version. So, even
though we are using a DB in 2005, the scripts will be
targeted for 2008. More info here.In order to change this behavior we have to go to
Tools -> Options -> SQL Server Object Explorer
-> Scripting and change the
"Script for Server version" option. There we can select the specific version we want
the scripts to be generated for.After changing this, it perfectly worked on 2005.Hope it is useful, thanksPP