sap* password in SQL server

[Former Member]

Dear All,

i want to change sap* password but i know how to do in oracle database.

sqlplus / as sysdba;

Delete from usr02 where bname = 'SAP*' and client = '000';

It will reset the password of sap* as pass.

But 1st time i m using sqldatabase i dont know how to do.when i connecting microsoft SQL server management studio

DATABASE->SAPID->TABLE. Using query but not working.

i login as adm.

plz suggest

Regards

Ashok

[anindya_bose]

Ahoke

Delete from <SAPSCHEMA_NAME>.usr02 where bname = 'SAP*' and client = '000';

Check the link below

[former_member204746]

a quick search on SDN gave me this topic:

..and you posted an SQL server question in the Oracle section.