Did you get any solution or article that describes the problem and the solution? Recently, I have also started seeing the similar issue. It would be helpful in case it...

Thanks for your response.

We are not using integrated security option. We are instead using a SQL server login to connect and run the reports. So, there shouldn't be a problem.

The...

Can you elaborate more about the problem.

The problem may be that the report is not mapped with the data source.

Check in properties tab-> data sources->

the radio button with shared...

Can you try enclosing the first statement in iif within the braces()

IIF((condition),true,false)

Just to add little information.

In order to have the email option in Report Delievery option while subscribing to a report, We need to configure few settings. The file rsreportserver.conf (generally...

Hey GianLuca,

Really appreciate the way you replied. 🙂

I thought of the same and changed the schema to the publisher and subscriber side ,added NOT FOR REPLICATION keyword. But later I found out that it doesn't do what...

Little thing makes gr8 differences. Thanks.

You can go for rank function ,partitioning on the salary column. Then u can filter your column to get any of the n'th max salary based on your query.

This is really a nice piece of information. I was just surfing the net and got this. It really made my life easy though I have to add some code...

Yeah!! thats right. The first one is virtual name and the second is instance name.

Anyway I got the fix. It was to use as ADAM(my virtual server name)\SANDLAR(my instance name)

Thanxs...

How to provide SQLSERVERINSTANCE NAME if it is a two word name something like ADAM\SANDLER

since it will take it as path in the PowerShell Script as the syntax is :

SQLSERVER:\SQLPolicy\SQLSERVERINSTANCE\DEFAULT).EraseSystemHealthPhantomRecords():-)

Can you clear your question and could you post your stored procedure . Without that its hard to give any suggestion.

If you are calling...

Thanks every1 for valuable suggestions. I went with the idea of changing default database along with creation of a DDL trigger on master database.

Thanks every1 for valuable suggestions. I went with the idea of changing default database along with creation of a DDL trigger on master database.