This is what i get from the sys.dm_os_waiting_tasks. What do i do from here. pls help.

wait_duration_ms wait_type

-------------------- ------------------------------------------------------------

2688 ...

Thanks a lot Markus. That really helped a lot.

Regards

Songezo

Firstly this is a permission issue. You must have sa rights to execute a any job. the reason why he does not see the databases is because he does not...

Here is the solution:

select

filename from sysfiles

that wil give you something like this :

F

:\MSSQL\MSSQL\data\DEVDAT.