Hi,

Thanks for the reply.results are the like, an select query runs for every 3 hrs(as a job) and the result of the query has to be send to the recipient...

Hi,

Thanks for the reply, actually my job is to mail the results to the recipient thru DBmail ,so i want to store the result to a variable and send it...

Thanks for your reply.

i need to generate the report and export it to excel , which will have 18 sheets on it.Its an monthly basis report i should run.

what shal i do now? any suggestions.

Its on Production , thats make me fear to run the query!!

No i dont have MSDB back

hi,

When i run DBCC CHECKDB onto MSDB , the follwing error ocuured.

Msg 8967, Level 16, State 216, Line 1

An internal error occurred in DBCC that prevented further processing. Contact Customer...

thanks for the reply.

do i need to run DBCC CHECKDB onto msdb or database?

Thanks For your reply.

i ran the query, it displys an error, but done the back up successfully.

Processed 325512 pages for database 'PGCENTURION', file 'SBOEdenvaleIntegration_RSA' on file 1.

Processed 41 pages for...

Hi,

I did,but the same error.

it has to be there the last back up path.

Hi all,

Thanks for your replies.Sorry i could not respond as i was on leave .My actual problem is when we right click on DB and select Task -Back Up ,...

For some branches the we need to provide space as the data is growing by the new applications installed on it.

Thanks for your replies.

So how can i reduce the size of the DB.For some systems it need to decrease the size of the DB.

Thanks for ypur replies.

so what can i do , just like shrink DB for a schedule task with out performing REindexing?

Regards

Ravi

Hi,

Thanks for your reply.

For the point 3 how can i update column statistics for all objects.

And also how can i take the log backup.

Is the query not performing the above...