Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-07-01 : 07:35:34
|
| R.Sankarasubramanian writes "Dear sir,I want to get the sql server user name pwd in a stroed procedure where it is runningi got the server name by @@server namei got the user name by @@system_userhow do i get the password for the current user" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-01 : 07:40:12
|
| You don't. Ever. If someone cannot supply the proper password, they cannot log in under that user name. There would be no purpose and no security in having a password that can be read by anyone. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-01 : 15:55:36
|
| This cracks me up. I needed a good laugh today (dealing with SQL Mail configuration problems).Tara |
 |
|
|
|
|
|