>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!

Sylvain,
AFAIK, there is no such thing in SQL Server. There are global variables but they are system defined.

Can use the user_name() function or do you use a singular login to authenticate your users?