in

ASP.NET Weblogs

This Blog

Syndication

Sponsors

advertise here

Tags

Pablo Peralta's Blog

Welcome to my blog. Here I will share some information, thoughts and comments about technology and management.

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

 

Published Dec 23 2008, 11:29 AM by pablop
Filed under: , , ,

Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
Terms of Use