You can use sp_password in the Query Analyzer the sintaxys is as follows sp_password [ [ @old = ] 'old_password' , ] { [ @new =] 'new_password' } [ , [ @loginame = ] 'login' ] the extra parameter is for the System Admin to change others people's passwords ex: sp_password 'sa', 'whateveryouwant'

I have a trigger that inserts every action made by the implementation department of my company, including the query, but when they use the Enterprise Manager the query is shown as sp_executesql;, but that isn't of any help for me, what i really need is the actual query that's begin executed by the sp_executesql, any help or clue would be greatly appreciated

thanks for pointing that out, i made some test myself and by lookign at your code i see that i was missing the OUTPUT statement in the parameters that were returning a value

acording to the SQLServer BOL, that can't be done, variables used within the query being executed by sp_executesql are local to the query therefore they can't be accessed by the query that executed it in the first place i hope i made myself clear with that :|