The people who originally setup the databases on our server have left and didn't pass on the password for the SA username. Is there anyway of extracting the SA password if I have access to SQL Server Enterprise Manager? I want to avoid resetting the password otherwise I the existing programs that rely upon that login name may not function problem. If anyone has any ideas I'm willing to give it a go.
Firstly - its not good practice - as you have just found - to have sa running any apps - you should change them asap to use another user ID ( and then you wont have this problem again ;-) , but I suspect I am now preaching to the converted.....).