Hi!

I'm wondering if I can create a temporary variable, in SQLServer 7 or 2000, which would stay in scope throughout the life of the connection. I could create a temp table, but that table would hold only a single value for each connection (namely, a user id to identify my users). So I'm looking for something that might be less "overkill" (if there is such a thing!).

Thanks!