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 |
|
SimonGough
Starting Member
23 Posts |
 Posted - 2001-12-10 : 12:25:16
|
| Hi, can anyone tell me if it is possible to pull a password from an SQL Server login in a stored procedure so that I can bring the string value back to my application for validation and if so, how?Thanks for you r help,Simon. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-10 : 12:31:20
|
| That would complete violate the concept of security! Think how easy it would be to hack YOUR SQL server if it was easy to do that.If you want to make sure that a SQL Server login is valid, simply try to connect using the login and password. The connection will fail with a trappable error message if the password is incorrect. |
 |
|
|
|
|
|
Pulling a password from SQL Server User