This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
John_Farkas
Level 4
‎May 28, 2008 06:17 AM

SQL Script running in Maintenance mode regardless of Schema

Hi, I am using InstallScript project and am using the Schema Version in the sqlscript gui so that scripts will only run against appropriate version of my database.
The problem I am running into is that when the Installer is run in repair or update mode the scripts run regardless of schema version. It's like the schema version is not checked at all.

Any help would be much appreciated.
Labels (1)
Labels
0 Kudos
(1) Reply
John_Farkas
Level 4
‎May 28, 2008 09:50 AM

Found problem!

Scripts were not acutally running but were throwing an error. Login to sqlserver was failing. Had to re-gather the sqlserver authentication details from the user before running the sql scripts in maintenance or update mode.
0 Kudos