Re-linking database user
Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn’t the same as the login name. use temp alter user TestUser2 [...]

Answer Question   |  October 2, 2008  12:18 PM
Alter user, SQL Server 2005, SQL Server database

SQL Server 2005 ‘alter user’
Hello, I have been trying to run the following instruction in QA use database_name alter user db_user_name with login = [domainlogin_name] but keep getting the error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ‘login’. I know this method exist in SQL Server 2005, are any of you able to run the [...]

Answer Question   |  August 20, 2008  12:45 PM
Alter user, SQL Server 2005, SQL Server errors