Managed to get the list using below query.

SELECT TABLE_NAME FROM [DB1].information_schema.TABLES

Where TABLE_TYPE='BASE TABLE'

EXCEPT

SELECT TABLE_NAME FROM [DB2].information_schema.TABLES

Where TABLE_TYPE='BASE TABLE'

Hi,

I had to come back again......

I used below code, only change in what has been suggested earlier is addition of an additional record so that I get duplicate values for...

This is Crazy and I am overjoyed.

Thanks to everone who took the pain to look into my Issue and been kind enough to give their precious time. Thanks Again..... 🙂

Hi Mark,

I am truly amazed by the quick response I am getting on this forum. I must say a Big Thanks before anything else.

On the code that you have...

Thanks Mark.....

Though I was trying to tweak your query for below requirement of mine. Basically there are mutiple columns which can have duplicate values and those need to be concatenated...

Terrific....Exactly what I needed and such a prompt response.

Super Thanks 😀

I am using SQL Server 2008 ( if that helps )

There is something more to it.

If the new Cube returns Null Data for some Selection and Constrained Flag is set to ON then this error appears.

The Solution to this...

Hi,

If there has been any change in reports(recreated ?) then have a quick look on parameters and ensure they have same Datatypes.

Hi Dan,

Adding a screenshot would have helped immensely to understand the issue. How "Adjusted target Area" gets twisted in the chart is as difficult to understand as it is to...

Thanks Many.

This surely would be of great help.

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/16eee49a-53d2-49cf-a7fd-9f6f10a1eb5b

Does this help ? In one of the replies...one fellow user has mentioned the steps as well.

Regards,

Athar

Hi Anthony,

Thanks for your help. Can I further request you to provide a little more info on Custom Authentication.

I have always used SSRS in sharepoint-integrated mode and so don't...

Screenshot isn't visible. Kindly attach it.

Issue is solved now? If yes, kindly let us know the correct solution for the same. Thanks.