There are various ways of using global variables in Microsoft SQL Server 2000 DTS Designer tasks. This article, one in a series, looks into their role in exchanging data between packages, using ...

In this, Part 4 of a series on programming T-SQL, Gregory Larsen details how to set variables in calling T-SQL code while using sp_executesql.

My belief is that server controls are first processed on the server side, which makes me think they would be a perfect companion for something like a Session Variable.