Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from sapbasis25 on Oct 8 at 9:40 PM Hi,
Please find the error
delete from d07.D07.USR02 where BNAME='SAP*' and MANDT=600;
Msg 208, Level 16, State 1, Line 1
Invalid object name 'd07.D07.USR02'.
i have not found any usro2 name in the tables at sql
*d07*.USR02 or
*D07*.USR02 or
*d07.D07*.USR02 klike this i have not found any files in the data base'
my login user_automatic is ==1 when iam doing all this activites
after successfull excute only in sql query
I have to make the value to 0 is it right
Kindly guide me for the next
| | | ---------------Original Message---------------
From: Navneet Kumar Vivek
Sent: Wednesday, October 08, 2014 4:04 PM
Subject: SAP Client 600 Has Been Locked (sap*.ddic,basis)
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 |
| 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.   _.____.__ |
