<div>
This is not neccecarily a problem. You can 'aliasname' a nt account in the database security part. In the server part it's named with its true name. Do you need to rename the account? Im not sure I understand your question. But if a rename is all you want to do then this should do the trick.<br />
<br />
ALTER USER [execTestReportAdmin]<br />
WITH<br />
NAME = exeRptAdm<br />
<br />
as always, do a backup of the DB before you run any code you dont fully understand. If applicable, run in a test scenario first!<br />
<br />
/Marten<br />

</div>


This is not neccecarily a problem. You can 'aliasname' a nt account in the database security part. In the server part it's named with its true name. Do you need to rename the account? Im not sure I understand your question. But if a rename is all you want to do then this should do the trick.

ALTER USER [execTestReportAdmin]
WITH
NAME = exeRptAdm

as always, do a backup of the DB before you run any code you dont fully understand. If applicable, run in a test scenario first!

/Marten


<div>
I have an acoubnt in the db as execTestReportAdmin, I want to change this to exeRptAdm<br />

</div>


I have an acoubnt in the db as execTestReportAdmin, I want to change this to exeRptAdm


<div>
<div class="content wysiwyg-content">
I had to create new windows NT logins , so I created an account with the following execTestReportAdmin, and requested that I can access a database dbActivity<br />
<br />
Then I requested that this user name be renamed as it was too long and was causing problem in storing this value in one of the tables<br />
So the &nbsp;nT group renamed it to exeRptAdm, but now when I log in to SQL Server, using this account and do <br />
select user<br />
<br />
I see the old login execTestReportAdmin<br />
Can you please what needs to be done, because I need to see exeRptAdm
</div>
</div>


I had to create new windows NT logins , so I created an account with the following execTestReportAdmin, and requested that I can access a database dbActivity

Then I requested that this user name be renamed as it was too long and was causing problem in storing this value in one of the tables
So the  nT group renamed it to exeRptAdm, but now when I log in to SQL Server, using this account and do 
select user

I see the old login execTestReportAdmin
Can you please what needs to be done, because I need to see exeRptAdm

windows NT login and sql login

The Windows operating systems have distinct methodologies for designing and implementing networks, and have specific systems to accomplish various networking processes, such as Exchange for email, Sharepoint for shared files and programs, and IIS for delivery of web pages. Microsoft also produces server technologies for networked database use, security and virtualization.

Windows Networking

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.