Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 creating a global variable

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-11 : 10:33:30
raz writes "hai,

i have a very peculear problem,

i want to create a global variable that is session dependent,

ex:

i am having database that is seen by different users,
each user wants to c the data in a specific language like english, spanish etc.
for that i have to set the langage code for each session,
can i create a global variable that can store a session value
like 'USER' so that i can store the language code for that.
so i can use that variable to set the session.,

i can do this by creating a database trigger,

but i don't have permissions to create that."
   

- Advertisement -