Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 5:07
sudevsu16-Jan-15 5:07 
AnswerRe: DB2 Store procedure error in VB.NET Pin
Jörgen Andersson16-Jan-15 4:01
professionalJörgen Andersson16-Jan-15 4:01 
QuestionRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:32
sudevsu16-Jan-15 4:32 
AnswerRe: DB2 Store procedure error in VB.NET Pin
Jörgen Andersson16-Jan-15 9:59
professionalJörgen Andersson16-Jan-15 9:59 
AnswerRe: DB2 Store procedure error in VB.NET Pin
Mycroft Holmes16-Jan-15 13:13
professionalMycroft Holmes16-Jan-15 13:13 
AnswerRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut18-Jan-15 21:47
professionalGuyThiebaut18-Jan-15 21:47 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu19-Jan-15 2:37
sudevsu19-Jan-15 2:37 
QuestionUser name changed in active directory, SQL Server shows old user name - FIXED! Pin
GuyThiebaut15-Jan-15 8:14
professionalGuyThiebaut15-Jan-15 8:14 
I have googled and it seems that this is a known issue - however I can find no guaranteed fix.

A person needed their name changing so the admins changed their name in AD and all seemed to go fine.
However I noticed that the SQL Server stored procedures using system_user or user are still returning the old name from AD.

There are some posts out there on google acknowledging that the SID maintains the link between AD and SQL Server however the name in SQL Server is not updated.

I am loath to bounce the server as it is used pretty much 24/7(and apparently it is not guaranteed to work).

So I am wondering if anyone else has seen this and knows how to get the name in SQL Server to pick up the new AD name(the user logs on via a group policy rather than as themselves).

[edit]
See SUCCESS post below for information regarding fix.
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens


modified 16-Jan-15 4:38am.

AnswerRe: User name changed in active directory, SQL Server shows old user name Pin
Richard Deeming15-Jan-15 8:55
mveRichard Deeming15-Jan-15 8:55 
GeneralRe: User name changed in active directory, SQL Server shows old user name Pin
GuyThiebaut15-Jan-15 9:01
professionalGuyThiebaut15-Jan-15 9:01 
GeneralRe: User name changed in active directory, SQL Server shows old user name Pin
Richard Deeming15-Jan-15 9:18
mveRichard Deeming15-Jan-15 9:18 
GeneralRe: User name changed in active directory, SQL Server shows old user name Pin
GuyThiebaut15-Jan-15 9:22
professionalGuyThiebaut15-Jan-15 9:22 
AnswerSUCCESS! Pin
GuyThiebaut15-Jan-15 22:37
professionalGuyThiebaut15-Jan-15 22:37 
QuestionIsolation Level Pin
Member 1137363813-Jan-15 19:07
Member 1137363813-Jan-15 19:07 
AnswerRe: Isolation Level Pin
Eddy Vluggen13-Jan-15 23:44
professionalEddy Vluggen13-Jan-15 23:44 
GeneralRe: Isolation Level Pin
Member 1137363814-Jan-15 0:30
Member 1137363814-Jan-15 0:30 
GeneralRe: Isolation Level Pin
Eddy Vluggen14-Jan-15 2:56
professionalEddy Vluggen14-Jan-15 2:56 
GeneralRe: Isolation Level Pin
Member 1137363814-Jan-15 16:57
Member 1137363814-Jan-15 16:57 
AnswerRe: Isolation Level Pin
Eddy Vluggen15-Jan-15 9:56
professionalEddy Vluggen15-Jan-15 9:56 
GeneralRe: Isolation Level Pin
Member 1137363815-Jan-15 17:15
Member 1137363815-Jan-15 17:15 
GeneralRe: Isolation Level Pin
Eddy Vluggen16-Jan-15 7:58
professionalEddy Vluggen16-Jan-15 7:58 
QuestionAudit Tables for Many-Many Relationships Pin
Matt U.13-Jan-15 3:40
Matt U.13-Jan-15 3:40 
AnswerRe: Audit Tables for Many-Many Relationships Pin
Eddy Vluggen13-Jan-15 7:49
professionalEddy Vluggen13-Jan-15 7:49 
GeneralRe: Audit Tables for Many-Many Relationships Pin
Matt U.13-Jan-15 10:00
Matt U.13-Jan-15 10:00 
GeneralRe: Audit Tables for Many-Many Relationships Pin
Eddy Vluggen13-Jan-15 12:49
professionalEddy Vluggen13-Jan-15 12:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.