SQL Server Connection script problem

Got a problem you cannot solve? Try here.
Post Reply
sdoc
Posts: 5
Joined: Tue Aug 26, 2008 3:22 pm

SQL Server Connection script problem

Post 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
sdoc
Posts: 5
Joined: Tue Aug 26, 2008 3:22 pm

Post 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:
Post Reply