In order to delete sap* from USR02
isql -Usapsa -SSID -w2000
Password:
1> use SID
2> go
1> select top 1 * from SAPSR3.USR02
2>go
1>select * from SAPSR3.USR02 where BNAME='SAP*'
2>go
1> delete from SAPSR3.USR02 where BNAME='SAP*'
2> go
We can now go ahead restart the sap system for the recreation of sap*.
