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 |
lokhande.shirish
Starting Member
4 Posts |
Posted - 2007-03-07 : 02:35:08
|
Hi,Can any one tell me how to find the User name and password by using sql statement. I am using sql server 2000. i.e Username = sa and password = abcshirish |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-07 : 02:39:13
|
You can't retrieve SQL Server user's password because it not stored in plaintext format within the system tables.For user name, you can query master..sysxlogins table.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-07 : 02:40:09
|
Passwords are encrypted, so you can't query them.What's the problem you are trying to solve? For example: has the only person who knows the SA password left? If so there are easy ways around that ...Kristen |
|
|
|
|
|