Sql Server 2008 Password Help

[netdevelooper]

how to find password of a user in a particular database of sqlserver 2008

thanks

[Josh]

Help

[Kedi No.486]

SELECT name, password, LOGINPROPERTY(name, 'PasswordHash' ) hash
FROM syslogins
WHERE password IS NOT NULL
ORDER BY name

[netdevelooper]

[quote name='Kedi No.486' timestamp='1374684099' post='1304004296']
SELECT name, password, LOGINPROPERTY(name, 'PasswordHash' ) hash
FROM syslogins
WHERE password IS NOT NULL
ORDER BY name
[/quote]

thank you but still am getting a error saying that
[size=5]Invalid object name 'syslogins'.[/size]

[gupta24]

[url="http://support.microsoft.com/kb/918992"]http://support.microsoft.com/kb/918992[/url]


bro edi work ayidi chudandi

[netdevelooper]

[quote name='gupta24' timestamp='1374685915' post='1304004602']
[url="http://support.microsoft.com/kb/918992"]http://support.microsoft.com/kb/918992[/url]


bro edi work ayidi chudandi
[/quote]
thank you

[netdevelooper]

[quote name='gupta24' timestamp='1374685915' post='1304004602']
[url="http://support.microsoft.com/kb/918992"]http://support.microsoft.com/kb/918992[/url]


bro edi work ayidi chudandi
[/quote]
my case is

oka database undi a database ki oka user and password undi.
a database acess cheyali ante user and password yevali web.config lo
user name guruthu undi kani i forgot password
so trying to retrive the password in sqlserver

[Kedi No.486]

follow this path required database/Security Under databse/ users under secuirty /Select Particaular user /rightclick properties

u will see password in general section ,change the password there and save it.

Use that password in Web.config file.