Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from navneet013 on Oct 8 at 4:04 PM 1. Did you try with d07.D07.USR02?
2. If no try and share the result for below
SELECT BNAME, MANDT from d07.D07.USR02 where BNAME='SAP*';
3. If query in Step 2 runs without any issue that means schema name is correct and you can then proceed to step 7.
4. If query in step 2 gives same error again i.e. invalid object name then your search for correct schema continues.
5. Login to command prompt from appropriate user (guess d07adm?) and fire below command
set | find "MSSQL"
Look out value of parameter MSSQL_SCHEMA and MSSQL_DBNAME to verify your database and schema name.
6. Again try query from step 2 but with new discovered schema name. If it works fine then go to next step but use correct schema name.
7. delete from d07.D07.USR02 where BNAME='SAP*' and MANDT=600;
Another method to get schema name for your MSSQL database:
1. Login to SQL Server Management Studio.
2. Expand your relevant database (might be D07 in your case).
3. Expand Tables (might take some time to populate the list).
4. Look out for your table USR02 should be at very bottom of the list.
5. Schema name would be prefix to your table like
d07.USR02 or
D07.USR02 or
d07.D07.USR02
| | | ---------------Original Message---------------
From: sapbasis25
Sent: Wednesday, September 24, 2014 3:10 AM
Subject: SAP Client 600 Has Been Locked (sap*.ddic,basis)
Hi,
sap dev client 600 client has been locked in all user ids. Kindly guide me in this.
I am not able to find the answer for this please guide.
Thanks
sap basis |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
