http://blogs.msdn.com/b/sqlserverfaq/archive/2009/07/24/how-to-impersonate-the-privileges-to-create-a-login-using-the-stored-procedures-using-execute-as-clause.aspxAs most of the times we do it in a simple way descirbed below. but when we try to do the same through stored procedure it fails. Just for information regarding impersonation:- http://msdn.microsoft.com/en-us/library/ms188354(SQL.90).aspx Solutionen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlserverfaq/archive/2009/07/24/how-to-impersonate-the-privileges-to-create-a-login-using-the-stored-procedures-using-execute-as-clause.aspx#10114690Wed, 12 Jan 2011 13:27:16 GMT91d46819-8472-40ad-a661-2c78acb4018c:10114690Annoyed SQL Server user<p>This did not work for me. Even with impersonation, the impersonated user test1 does not have server scope permissions or permissions in other databases.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10114690" width="1" height="1">