How to unlock SAP* at MS-SQL database level

[Former Member]

Hi All,

Somehow all the users in client 765 has been locked,we have MS-SQL database.

Could you please let us know the way to unlock the SAP* from database level.

Regards,

Prashant

[Former Member · Accepted solution]

Hello Prashant,

This has been asked and answer several times. Anyways please check the link:

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/how-to-unlock-sap-in-mssql-server-188...

Regards.

Ruchit.

[Former Member · Accepted solution]

Thanks

[Former Member]

update <sid>.USR02 set UFLAG=0 where BNAME='SAP*' and MANDT=765

Edited by: Rajnikanth Talanki on Jun 29, 2010 4:21 PM