Any help from anyone who knows what I might have set wrong would be greatly appreciated...

Yes, report builder asks for password on connect and on the wizard.

It is truly on the Internet: we have about 2000 users who connect remotely on separate domains. ...

Sorry MM, I normally do check that box and just tried again with it ticked, same outcome and same error... Is there something that needs to be done to open...

Does anyone have any ideas to help on this? Your help is greatly appreciated!

MM,

I don't see how to post screen shots here, so I've made a video here to show me able to do the same steps on the server but not on...

MM,

Thanks for the reply.

Let me explain the whole scenario and maybe it can help. I think I have the answers to your questions, but I'm not sure....

Can anyone help out? I'm really stuck and don't even know where to turn to look for advice on how to make this happen. I would appreciate it...

I have tried and tried and can't seem to get this view to build since upgrading to SS2008R2. If I manually MAKE a view it will drop it (when...

Gianluca, you are brilliant! The problem was not in your code, rather that all table names were 'inspecitons' and I was missing the 'S'.

Thanks again!

P.S....

I tried modifiying/adding the code to what I thought should be changed. Here's what I put in the procedure:

ALTER PROCEDURE refresh_view_for_inspection_tables

AS

BEGIN

SET...

Here's the union on how these particular three are related:

SELECT FacilitiesList.Name

FROM FacilitiesList INNER JOIN

...

How would this work for combine multiple different tables though? The way I'm reading it, each set would need it's own stored procedure, right? For instance, the 3...

Thanks Gianluca, but it seems as though this would be pretty complex. I also forgot to mention that we have 5 sets of theses tables, so it appears at...

OK.... I've never done this before, so I'm not sure how to test it. I tried running it as a Query from Visual Studio 2008 and get errors. ...

Thanks for all of the information everyone. Unfortunately it took me a bit to get back to the project since I have a million other things going on. ...