Hey thx for the reply ,

SQL version is 2008 R2

Any comment about this ?

EXEC sys.sp_configure N'user options', 0 RECONFIGURE

HI All ,

I came across an article about this ? Link http://sqlblog.com/blogs/eric_johnson/archive/2009/12/23/troubleshooting-a-failed-maintenance-plan.aspx

EXEC sys.sp_configure N'user options', 0 RECONFIGURE

What do you if I execute that statement?

PS : I enable output...

Hi Gail,

Thanks for the response . The error from output file is : The package execution returned DTSER_FAILURE (1)

Cheers

Hi..

I run DBCC Checkdb again using your recommended script but the error is still the same . I tried to run manually ( in query window ) then I got...

OK I will run it tomorrow nite and keep you posted

Many thanks for your feed back

Hi..Thanks for taking time to reply my posting .. Yes I have tried it before and still need a restart ?

actually what is the benefit of having that db?

It worked !!

I copy mdf and ldf from another server to this problematic server , I successfully start the engine and applied patching !!

guys i check in SQL log

it says " Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space."

How do i fix this please ?

Thanks for your kind feedback guys .. really appreciate it

Hi ....

Thats a very good idea ...

I asked my team checking that particular client application ..

Thanks for the feedback . Appreciate it !

I feel the same actually ...

Many thanks for the feedback .

How do i trace it back to a hostname ?

Moreover I am able to connect sql using that username and password ..( via SSMS )