how to delete sap* from MS SQL

[senthil_kumar29]

Hi,

Could you tell me regarding how to delete sap* from MSSQL for client 000.

I know how to do in ORACLE but in MSSQL how to do it?

can you give me steps ?

Thanks senthil

[senthil_kumar29]

Thanks Guys..

[Former Member]

Don't forget to check your profile parameters.

If you have the following parameter set

login/no_automatic_user_sapstar = 1

You will have to change it to 0 and restart SAP before the default SAP* credentials will work after deleting the SAP* row in USR02

[Former Member]

Hi,

run query analyzer if you use SQl server 2000

or run sql server management studio if you use SQL 2005

connect to database

use folloiwng query

in SQL 2005 click on new query

USE SID

DELETE sid.USR02 where MANDT='800' and BNAME = 'SAP*'

where SID = your sap system id ID in uppercase

sid = your sap system id in lowercase

query is case sensitive

reward if helpful

regards,

kaushal

[Former Member]

Thank you

Satish