CheckDB failed in CRM 4.0 and SQL2005 SP1

[Former Member]

Hello all,

I have a CRM 4.0 an SQL2005 SP1

- The kernel patch 640 is 221

- BASIS and ABA level is 60

When I execute a CheckDB by DB13 transaction the next error appear:

"Could not find stored procedure 'dbc.sap_new_dbcheck'. [SQLSTATE 42000] (Error 2812)"

I've tried to recreate the stored procedure by MSSPROCS report, but in the database is missing still.

Could you help me with this problem, please?

Thank you very much in advance and best regards.

Emilio

[Former Member]

Hi Emilio,

can you please goto SE38, execute MSSPROCS and display the stored procedure

sap_new_dbcheck?

I've seen one case by now, when the part, that is creating the stored procedure, was commented out: in this case it looks like:

[...]

CREATE procedure sap_new_dbcheck(

@dbname varchar(30),

@outputfile nvarchar(200)=NULL ) as

begin

SET NOCOUNT ON

for testing:

select @dbname = 'master'

[...]

if this applies to you please remove the comment marks in front of the lines (--)

in order that the procedure sap_new_dbcheck is really created again, if you run it in MSSPROCS.

Regards,

Beate