Thanks!

Thanks I will check that out.

Looks like there isn't a button to "maximize" but to grow to full width and then separately to full height.

I was really hoping SSMS had...

That makes sense.

Though I would have to host the entire install file on my servers right?

No way around that really?

CANCER (9/8/2010)

---

I guess database mirroring is not possible, my report db is on differrent server. I need my report database to be always in synch with up to time data...

You could use database mirroring to basically create a read only copy of your production database.

That mirrored database is what you would report off of, so that your report queries...

I know this isn't overly helpful... but we just had all our users export to PDF and print that way.

I know, I know... but I found it tended to do...

If that is on a Windows Server OS that disables a lot of "features" in Internet Explorer to make it more secure, so I would bet that is why it...

Can you be a bit more specific?

A report that runs at a scheduled time? Will it email itself to someone? Something like that?

Here is a link to Technet...

Can you include a screen shot of IIS? What sites do you have setup?

Is there a site called Reports that IIS is showing?

Try this: http://blog.mtfrog77.com/2010/02/how-do-i-make-our-sharepoint-site-stop.html

It talks about SharePoint, but the same issue.

If I understand you properly what you are describing is that Internet Explorer is asking you for your domain...

I can answer with a link:

http://blogs.msdn.com/b/robertbruckner/archive/2008/11/03/technical-note-series-on-reporting-services-performance-and-scalability.aspx

They have articles about scale-out architecture, placing the report catalog (the reporting services databases) best practices, etc...

If you are going to have more...

Steve Newton (8/29/2010)

---

I had a very similar issue and would suggest you look into this which fixed my issues. I was calling Stored Procedures in my SSRS reports and...

Thank you, that second set of queries executed almost immediately!

It looks like they return zero rows though, so if I understand that correctly it means there have been no deadlocks...

When I run your query on my server.... it never finishes! 🙂

I have let it run for up to 13 minutes... still nothing.

----------

select CAST(

REPLACE(

REPLACE(XEventData.XEvent.value('(data/value)[1]', 'varchar(max)'),

'<victim-list>', '<deadlock><victim-list>'),

'<process-list>','</victim-list><process-list>')

as xml) as DeadlockGraph

FROM

(select...

Tara Kizer (7/19/2010)

---

Sorry Maxer that data isn't available in that part of the Activity Monitor. It's available in the Processes report, which is what I thought you meant until...