Is the name of the job the same or the name of the schedule on each server? If so again query the job or schedule tables to get the...

Check the schedule of the job which is running the task.

Otherwise query msdb.dbo.backupset which will help contain the information you need.

Have you checked the path which the DB thinks where the log is, is actually where the log is, or someone hasn't deleted the log?

Do you have any backups for...

Permissions roles etc will all depend on how you want to lock down access to the databases, only you know what the applications are doing to the database so only...

can you dump out the sql, windows and cluster logs into a zip file and attach to the post, might be worth a second (or many) pair of eyes looking...

Can you post some of the values which are in the columns so that we can try and find a solution.

check the executionlog view in the ReportServer database, check windows logs, sql logs etc, but you will be lucky, that error is so generic that it could be literally anything.

You would want to do something like this

SELECT Class, sum(SumofInvoiceValue), sum(SumofCostPrice), Margin

FROM SalesByClass_Three

WHERE (Invoice_Date BETWEEN @startdate AND @enddate)

group by class, margin

Swings and roundabouts on that one, two folders one for xls the other for txt or two loops one for xls the other for txt will provide exactly the same...

I would load the data into a a staging table which can take it all in as a varchar, then perform a conversion from the staging table to the actual...

Please do not cross post, replies here please http://www.sqlservercentral.com/Forums/Topic1364523-148-1.aspx

Interaction will not work in PDF, you could try exporting the MHTML instead as it should act just like the webpage and pass you through the the report server again...

SQL is behaving as you told it as it is grouping correctly. What you will need to do is remove the date field from the data set so that...

Object reference not set to an instance of an object could mean a million and 1 things.

We can't tell you what is actually wrong just by that error.

I would suggest...

One way would be the need to compare each column individually like below.

SELECT

ID,

Name

FROM

EMP_TBL

WHERE

ID IN (1,2)

AND

Name IN ('foo1','foo2')