Agreed. Just wanted to inject some additional potentially useful info regarding the issue. I'm always looking to pick up tidbits on things I didn't know about. Can be useful down the road. :-)
Bill
>Hey, Bill,
>
>Thanks for the info. That's correct, as BOL states...
the scope of local (user-defined) variables is limited to a batch, and cannot be referenced after a GO command. And as Magnus pointed out, all local variables would go out of scope.
>
>At the risk of repetition, I think Dan LeClair provided the best advice on this.
>
>Kevin
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.