Thanks for the reply.

That's interesting, if that's the case I think it might come down to the SSMS version. The user I'm supporting might be using SSMS express?

No I didn't.

I'm in the local administrators group so it shouldn't matter but I'll try anyway.

Have you checked the Reporting Services log files for errors?

C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles

Excellent, thanks very much.

Thanks Gail, that helps with the order of operations 🙂

Is there some literature I can read up on that explains why it doesn't matter?

Thanks Again.

-Tom

Hi there,

This may be of interest to you;

http://sqlloadgenerator.codeplex.com/

Or the following simulates SQL Server activity on a disk subsystem;

http://support.microsoft.com/kb/231619

Bueno Suerte!

Hi, thanks for your reply, you are absolutely right, it does work.

I was making a mistake elsewhere, all resolved now.

Thanks again.

It is just an example, the cursor here just gets the DBName and I try and change to the context of that DB.

I know it's not actually do anything as...

Cool, thanks for the reply and the links.

I'll do some testing and check out the execution plans of the different methods. Seems like using the "Union" method could lessen to...

Lynn Pettis (12/11/2012)

---

tom.moore.777 89426 (12/11/2012)

---

The user has the same permissions as other users who are able to see 'Script View as'.

They can even script out other objects (Tables, Functions, Stored...

@dba@SQLFRNDZ

Any particular option in Tools -> Options -> Object Scripting Options ?

I have had a look in here but there is nothing directly related to Views, except...

The user has the same permissions as other users who are able to see 'Script View as'.

They can even script out other objects (Tables, Functions, Stored Procs etc), however the...

It's not a System View, and yes I agree you should be able to 'Script View as' on user defined views, but the option is missing.

Yes that's correct Lynn, when I right click on a view in Object Explorer in SSMS?