DBCC does not return anything and also nothing from DBCC CheckCatalog.

I know there is a schema corruption and need to drop and re-create the table.

Thank you very much...

Thank you very much to help me out.

If I knew I would not have posted here. I would very much appreciate if someone shed some light on it please.

when I upgraded I upgraded all the tools also.

Any one on this please.....

so this will work right. And after running this I always run full backups anyways.

CREATE PROCEDURE SP_SHRINK_LOG

AS

BEGIN

DECLARE dbNames_cursor CURSOR

--

-- Run this script routinely to control the growth of LDF log...

i don't see the @name as well as i do not know what is the @name for

no did not work says

Msg 119, Level 15, State 1, Line 1

Must pass parameter number 6 and subsequent parameters as '@name = value'. After the form '@name = value'...

by the way the error says

Msg 22050, Level 16, State 1, Line 0

Error formatting query, probably invalid parameters

Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 495

Query execution failed: Msg...

hi i am using the below to send me the email but i am not able to get it instead i get an error

exec msdb.dbo.sp_send_dbmail

@profile_name =...

Actually i need the step-by-step instructions.

no idea how to do that. and the ways you says will just send me an email that the job succeeded but not the...

thank you. atleast this might help me at some point.

any idea friends???

this returned me null columns. and not what i expect. any thing i am missing here