I tried excel extension also. Still most of the values going out of area and mixing with next column.

I ran like this

sqlcmd -S SERVERNAME -d Master -i sql_query.bat -o output_file.txt

It is working but just I need to change the output format to understand the query result...

No.

They don't want to make any changes to the databases. They need the select query (DMV) out put to the filesystem

I am trying to figure it out the route cause for the failure.

I created and ran the new maintenance plan but the same issue

I ran the job using sa account

I...

I am able to create new maintenance plan. But the same error when tried to run that

There is another job scheduled to run the full backup of one db to the network path. It is successful but the backup & Check db jobs which were created...

This should run daily

To easily recognize, I think dev prefix as Sp_name but most of them are spname only

Thanks

Is shrinking the log blocks the other transactions? Do it requires downtime?

Thank you

These are the blocking statements. How to disable that delete statements

delete top(@TemporaryMappingCount) CSM

output deleted.ChunkId, deleted.SegmentId into @cleanedSegments (ChunkId, SegmentId)

from [ReportServerTempDB].dbo.ChunkSegmentMapping CSM with (readpast)

join @cleanedChunks cc ON CSM.ChunkId = cc.ChunkId

where not...

I don't think it is trying to access any xml. It is using sp as dataset

If we change that option now, is this required to reinitialize again

Any help on this issue. The issue is still continuning. Some reports are working from the website but some not.

Is this related to the memory or any other resource issue?