Page 1 of 1

SQL Server Connection script problem

Posted: Thu Dec 04, 2008 4:47 pm
by sdoc
I hope someone can help me here. I want to run the SQL Server Connection script( from sample) only when checksql2005 script returns a TRUE in the SQL2005 variable.

However I am having trouble with the fact that to do recursive screen (List the Servers-> Pick Server-> Connect To server-> Try Again) the SQL Server Connection script is using a Label-Goto Label

If I try below in my main script I get an error about Label not allowed in IF-ELSE
<PseudoCode>
If Variable SQL2005 Equals TRUE
Include Script SQLServer Connection
End


If I try below in the SQL Server Connection script I get LABEL re-defined error
<Psedocode>
If Variable SQL2005 Equals TRUE
Goto Label :Skip The Script
End
…
…
Label: Skip The Script //last line in script

Posted: Thu Dec 04, 2008 5:04 pm
by sdoc
i am so sorry for the post. I realized my issue. I was calling the script twice,due to an uncommented line. :idea: