Syntax

alter user user_name with login= login_name

eg.

Setting login1 as default login for user user1

use db1

alter user user1 with login=login1

You may also Interested in

• Windows 7 IIS ASP SQL not working
• ASP MSSQL Connection
• find number of days in a month from ms sql server
• Change Default User for
• Comparison b/w MSSQL and Mysql