This was very helpful.

A rider question ( 2 in fact ) is why this odbc connection will not work in 2 scenarios ?

1. If I use openrowset , i...

I just looked up in Google again for good measure and I saw this link and it worked for me.

It was so quick and easy.

http://www.sqldbadiaries.com/2010/10/25/addremove-checkpoints-manually-on-a-cluster/

get teh list of...

the article in reference did not help . for a cluster .

I have identical probelem.

Any help is appreciated.

I saw one reference where one could use cluster.resrouces and...

I ended up deleting the files that are old...to reclaim the disk space.

Thank you so kindly for the tip.

It seems this has happened to some others as well. It is a mystery ...

The work around suggested is here[/url].

But I ended up...

The error says it is internal error. ( most probably you will not get much more info even in the RS Server logs .. but that is your best bet...

No does not help. Also , I have tried to use the modified code posted by another user in this thread. Even with that , I get error like below:

Msg...

I get this error after getting to the 906th line in the table ( dbo.catalog)

Is my Row number 906 of the table corrupt ?

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

Msg 9412, Level 16, State 1,...

Thanks. Appreciate the hint.

I did a profiler and got the showplan xml files.

Yes indeed. In SSMS there is a Clustered Index scan( 28%) , where as in SSRS...

Very helpful.

I see in my case lot of files with very old date stamp like 2009 , 2010 etc.

Can we delete these files ? Since they are only temporary files...

I think once you have SA role and Content Manager ROle , you should be able to take over ownership.

I have never doen this myself though.