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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-04 : 09:05:24
|
| Arslan writes "Hi,Iam migrating a database from oracle 9i to sql server 2005. There is a stored procedure in Oracle which uses DBMS_SESSION.set_context and sys_context functions. I have tried hard but unable to find any equivalent in sql server. Any suggestions?Regards,Arslan Ahmed" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-05-04 : 09:07:07
|
| The closest concept in SQL Server that I can think of is the context_info column in the sysprocesses table. It allows you to set data that is maintained for the duration of the session or until you change it. Books Online has more details under the "SET CONTEXT_INFO" command. |
 |
|
|
|
|
|
DBMS_SESSION.set_context problem