Jack_Thiru from chennai (11/25/2009)
If you give one simple and sample example for ALTER users. it will be help every one who looks for a solution for this kind of problem..
If you do a quick google search, you'll easily come up with more than one simple and sample example
http://www.google.com/search?q=ALTER+LOGIN+site%3Amsdn.microsoft.com
http://msdn.microsoft.com/en-us/library/ms189828.aspx (SQL 2008, has a link to the 2005 one)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability