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 |
|
arvenger
Starting Member
4 Posts |
 Posted - 2007-11-14 : 04:12:49
|
| Hi, Iam facing Problems Due do migration of the Database from SQL Server 2000 to 2005. A procedure which used to run fine is now not running because the CONTEXT_INFO variable is not getting set, because of this i cannot retrieve the details of the user that has logged in at the moment, its a multi user application. Need some real help immediately ,like is there any other variable in the master ... sys processes table which gets set apart from the CONTEXT_INFO, so that it can be used for determining the user who has logged in?Thanks."What's in a name? That which we call a rose By any other word would smell as sweet."--- FakeSPEAR! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-14 : 04:31:14
|
[code]SELECT SUSER_SNAME(), USER_NAME(), SUSER_NAME(), USER_NAME(), CURRENT_USER, SESSION_USER, SYSTEM_USER[/code]
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
arvenger
Starting Member
4 Posts |
Posted - 2007-11-14 : 04:35:13
|
| these are columns which are part of the sysprocesses table?"What's in a name? That which we call a rose By any other word would smell as sweet."--- FakeSPEAR! |
|
|
|
arvenger
Starting Member
4 Posts |
Posted - 2007-11-15 : 12:58:14
|
| Yes but that doesnt help because these values return the login specific to data base login ID's, what i want are login id's used in the application. The procedure that we followed in SQL server 2000 was that on user login we set context_info value to the userid value which is of int type by converting to varbinary and storing it in context_info of the sysprocesses view, and using it to determine the user in the specific session for the specific spid. but the problem with SQL server 2005 is that it is not allowing us to set the value CONTEXT_INFO manually, so i want to know if there is any other column which can be manually set in the sysprocesses? or any work around for this problem, thank you Peso."What's in a name? That which we call a rose By any other word would smell as sweet."--- FakeSPEAR! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-15 : 23:20:01
|
| Did you look at sys.sysprocesses view? |
|
|
|
arvenger
Starting Member
4 Posts |
Posted - 2007-11-19 : 07:41:26
|
| yes that is the view am talking about, which has these values of context_info, we used to set that value of context_info previously in SQL 2000 but now we are unable to set the user if (after conversion into varbinary (which is the data type of context_info) and assiging its value to conext_info.need help immediately, thanks a lot."What's in a name? That which we call a rose By any other word would smell as sweet."--- FakeSPEAR! |
|
|
|
|
|
|
|
|
Problems Due do migration from SQL 2000 to 2005