CCMS_CHECK_DB_HIST_2013.txt. Writing to log files is only allowed to

[Former Member]

Dear Expert

I have followed below note for the above problem Note 1637915 - DBCC Checkdb joblog  output contains warning message

e) Then cut and paste the scripts one by one in the query window and create the stored procedures in the SAP Database.

I have confusion to create the stored procedure please advise about that.

For SQL Server 2005, run the scripts sap_new_dbcheck.txt and  sap_add_dbccjob_s5.txt.

Regards

[former_member184473]

Hello Anwer,

You must connect to your SSMS (SQL Server Management Studio), open a new query window to your database <SID>, paste the two scripts (attached to the note) and execute.

Regards,

Eduardo Rezende

[Former Member]

Dear Eduardo

I did exactly as your advised, its executed successfully then I go to SAP to check the stored procedure, the old procedure codes still exist and did not replace by new one.

However, before I was able to schedule and run DBCC Check DB job in DB13 but now its giving error in SM21 during scheduling.

Database error 137 at OPC

> Must declare the scalar variable "@dbName".

Database error 137

Regards

[former_member184473]

Hello Anwer,

Remove the DBCC job from DB13 and from SQL Agent (if necessary). Then recreate the job on DB13 and let me know if the issue persists.

Regards,

Eduardo

[Former Member]

Dear Edurardo

I have deleted job from DB13 and from SQl Agent , then I re-created the job  in DB13.

the problem is same during the DB13 job while click on preview.

Error in getting the SQL statements

Must declare the scalar variable "@dbName".

SM21 result

Database error 15250 at OPC

> The database name component of the object qualifier must be

> the name of the current database.

Regards

[Sriram2009]

Hi

Kindly refer SAP Note

1899404 - SQL errors 15250 and 15234 appear in the system log

1665356 - MSSQL: Update Tabstats job fails with SQL Error 15250

Regards

Sriram