3
Nov

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)