ok that's fine, but can you advise on my original point?

What to do with the NDF which contains the 1GB?

How do I restore the MDF to what it was?

Do I...

Hi Gail,

Thanks for replying.

Yes, sorry I knew log was in different filegroup - typo.

I have a warehouse server (2k8) with limited space available on one drive.

Used 99GB out of 100GB...

sorry ignore last post - I found it

anthony.green (3/12/2012)

---

you would want to take a look at the action tab on the chart properties

http://msdn.microsoft.com/en-us/library/aa964128%28v=sql.90%29.aspx

Around half way down is this sub heading "7. Add a drill-through action on the...

You could try a derived table expression using the WITH construct, something like:

WITH <table> AS

(SELECT ....

)

SELECT

.....

where...

You have a few options generally, although I'm not entirely sure what you're trying to achieve.

a) add computed columns to your T-SQL statement

...

... or failing the in-house resource, assuming you have some capital, then Dundas is very powerful

Forget all that. Do it in-house like I did! 🙂

Check SSRS setup in

Programs -> Microsoft SQL Server XXXX -> Configuration Tools -> Reporting Services Configuration Manager

Check Web Service URL and Report Manager URL

Also,...

I'll second that. All that's required is to add the extra fields you need into your SELECT and GROUP BY clauses, assuming you have JOINed to the relevant tables.

You need to jointly consider conflicting permissions as well as any DENYs.

Firstly, establish if your login/account is a member of other windows group logins.

The lowest privilege level will be the...