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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 User Name And Password

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 = abc

shirish

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 Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -