Performance Dashboard reports are based on dynamic management views and functions, new to SQL Server 2005.

The data returned by these objects resides exclusively in memory and is stored by the...

no problem, thanks.

I will contact MS Support and post their reply here.

no problem, thanks for your help.

I will post the MS reply here once I get it.

I will contact MS Support with this issue and will post the resolution here once it becomes available.

Yes, all boxes...

It seems to be an issue with double-hop Windows authentication.

The way I have been able to deal with this issue in the past is to define my DataSources with SQL...

Dinesh Asanka (1/30/2008)

---

Your report is trying to access the data source named 'Dynamic_Connection' which is not existing or invalid.

1. Go to report properties and assign correct dataq source

or else

2. create...

Here is some more info from the Report-Server Log:

System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I am not using a drop-down list, but instead a single-column table. I make my selections by clicking on each textbox on the table and by configuring the Action property...

Slightly off topic, but if you are planning to re-define your clustered index on one or more non-identity columns, choosing keys found in GROUP BY/ORDER BY clauses is going to...

Thank you Chad, this is worth trying out. It's always a good practice to get to a piece of data from multiple routes, especially as a sanity check. Such an...

Thank you Gail, much appreciated.

Apologies if this is not the right forum for code samples, but here is a quick example of how to set up a sproc called CLR_usp_CopyFile to copy files. For...

Thank you Adam, will do

Inside MICROSOFT SQL SERVER 2005: T-SQL PROGRAMMING

by Itzik Ben-Gan

Solid Quality Learning

is a great introduction to SQL CLR