Thank you.

It is working fine now.

Yes. I understand the error but when I use the cast function, it has to change the datatype but still I am getting issue

select cast((bp.id) as varchar(50))

bp is the table...

Actually that database is configured for mirroring.

Is that causing any issue? How to figure out why I am unable to add file the secondary file group.

I created 2 secondary file...

Hi,

I can't provide the execution plan but the query is

select serialnumber from sampletable where id in (1,2,3)

Yes. I use the quotes

WHERE id IN ('1', '2', '3'), it is better now

but still there is more cpu time in the message from the execution plan.

Also still I...

Hi,

If the Partition key has null values what will happen? Is it allowable or not. I read that all the null values goes to left partition.

Any suggestion if the...

Hi,

We deleted the subscription and recreated but still the same problem. Not able to find why the report is executing twice and how to stop?

Thanks in advance

I didn't see any errors under sql server error log

Please let me know how to check? I read some posts but not clear about that.

Sorry.

The report server instance is 2012.

Hi Shawn,

Sorry I saw another Job schedule but for that report subscription job scheduled is only one time. i.e. job is running only one time. But how if we see...

Here I am getting both date_created and date_modified are same values.

i.e. no one moified the job but how I am getting the report twice

Yes. MSDB is in simple recovery model only.

How the recovery model and job updates are related here. I am thinking Recovery models are useful in restoring scenarios

Thanks Shawn.

So you mean, if I reschedule the the subscription automatically it delete the previous sql job and creates the new job.

Rescheduling the subscription will solve the issue

Hi Shawn,

I go and check the reportserver executionlog.

For the same reportID

I can see different times from 2 days. Can you check the below attachment pls.

i.e. I am thinking it...