February 26, 2010 at 5:06 am
Hi,
Today one the server ,i logged in with DB\xxx login.but when i execute
select suser_name() , i got different result ( DB\yyy).
how it can happened ?
IS it some thing to do with Active Directory ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 26, 2010 at 5:26 am
Maybe because your login name on the server is different from the user in the database?
February 26, 2010 at 5:33 am
Here DB stands for "DOMAIN" and XXX stands for my profile name . is there any chance that
login and user can be different ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 26, 2010 at 5:49 am
The login name in sql can be different from the user name on the db, can you check it? It probably has nothing to do with AD.
February 26, 2010 at 6:57 am
No , this is same but i also tried to changes user name like
i rename DB\XXX with BK but still select suser_name() gives DB\XXX
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply