3
Nov
Get Server Username and Change Password in SQl Server5.052

How to get current server username in sql server using select statement below,

–Get Current Server Username
SELECT SYSTEM_USER AS ServerUserName

Results :

ServerUserName
——————————————————————————————————————————–
sa

How to Change SQL Server Password,

–Change the Current Server Password
sp_password ‘CurrentPassword’,‘NewPassword’


VN:F [1.7.4_987]
Rating: 5.0/5 (2 votes cast)
VN:F [1.7.4_987]
Rating: +2 (from 2 votes)

Tags: , , , , , ,

This entry was posted on Tuesday, November 3rd, 2009 at 3:49 am and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or TrackBack URI from your own site.

Leave a reply

Name (*)
Mail (*)
URI
Comment