Click here to Skip to main content
15,353,547 members
Home / Discussions / Database
   

Database

 
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
Membersudevsu16-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
Membersudevsu19-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 
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 
I suspect you'll need to rename the login within SQL.

Try:
SQL
ALTER LOGIN [Domain\OldUsername] WITH Name = [Domain\NewUsername];



If this is a Windows login, the SID of the Windows principal corresponding to the new name must match the SID associated with the login in SQL Server.




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


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
MemberMember 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
MemberMember 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
MemberMember 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
MemberMember 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
MemberMatt 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
MemberMatt 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 
AnswerRe: Audit Tables for Many-Many Relationships Pin
Mycroft Holmes13-Jan-15 11:42
professionalMycroft Holmes13-Jan-15 11:42 

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.