If you would like to use one select statement to insert into 2 tables at the same time you can setup view with trigger and write the insert statements within...

HI,

not sure if this is what you are after but try with pivot table:

SELECT testname, [E4],[E9],[W1],[W10],[W2],[W3],[W5],[W6],[W7],[W8]

FROM

(SELECT testname, FailedCount, Testtype

FROM testtable) p

PIVOT

(

SUM (FailedCount)

FOR Testtype IN

( [E4],[E9],[W1],[W10],[W2],[W3],[W5],[W6],[W7],[W8] )

) AS pvt

order by...

Hi,

You might be all right with setting up db_datareader role for accessing tables and views. In your situation make sure the users have connection permissions to the server.

Hi,

I think the quick solution is to backup and restore booth ReportServer and ReportServerTempDB database into new box. Then on the server that you run the SSRS service go to...

Hi,

I had similar problem and it turned out when i removed some rendering format.

in ReportServer folder on the server check your rsreportserver.config file and in RENDER you should have:

Extension...

Hi,

I am looking into similar strategy as well. At the moment I have implemented the log shipping on 20+ databases. However I have used 3-rd party software to do backup/restore...