A few options suggest themselves. Using LAG instead of PARALLELPERIOD might be a possibility, or you could look at this solution, and adapt to suit your needs.

I have to agree with those who have asked for the version of SQL Server to be specifed in future. SQL 2008 clearly states a value of 0 as the...

First, check your Windows\Assembly directory (usually C:\Windows\assembly) to see if the dll is present.

If it isn't you need to open a command prompt with Run As Administrator, then use gacutil...

There's a MS Connect item that flags this behaviour when connecting to remote servers. Does the account you are using have Performance Counter rights?

SQL-Student (2/15/2010)

---

Hello All,

If I am implementing partitions on a very large table, and the table has indexes. Is the index content divided amongst the partitions the same was as the...

Just a thought - have you checked the config files to see if anything is commented out or missing compared to the other reporting servers?

Which of the suggested actions have you not been able to do? Logging in with a domain admin account to check your permissions?

Which OS are you using on the server?...

Starting with the obvious, I presume you have:

1. Logged onto the server hosting SSRS and confirmed that you are actually a member of the Administrators group

2. Logged onto the server...

howyue (2/8/2010)

---

.... At this point of time, it looks like MCITP SQL 2005 is no longer valued with the existent of SQL 2008. ... Will SQL 2005 cert still be...

Looking at your execution plan, you've got RID lookups which are using a row identifier to select the rows you need because of the lack of clustered indexes on those...

I've had this issue in the past with native backups. I found that xp_delete_file worked:

EXECUTE master.dbo.xp_delete_file

0, -- delete files

@path, -- full path to the main backup directory

'bak',...

Something like this, perhaps?

SELECT * FROM fn_trace_getinfo (0); --Get your server's default trace details

SELECT loginname, loginsid, spid, hostname, applicationname, servername, databasename, objectName,

e.category_id, cat.name, textdata, starttime, endtime, duration,...

Without intending to muddy the waters, there's one area where the 'get more hardware' approach can be argued to be the right one: concept prototyping. If you need to get...

There definitely was a 'feature' regarding how MSDTC could be set up on clusters, from 2k servers onwards. Glad to see they've finally patched it; sorry you had to find...

SQLSpy from HybridX (http://www.hybridx.com/SqlSpy.Aspx)