You will be lucky trying to find out what caused this unless you have some sort of custom monitoring tool which polls your server seeing that is going on.

If the...

You would create a condition on the database facet, for the name object and give it the names of the DB's you want it to check, then it uses that...

You could use dynamic SQL

DECLARE @UseIt varchar(20)

DECLARE @Grade int

DECLARE @AppleFlag int

DECLARE @PearFlag int

DECLARE @BananaFlag int

DECLARE @sql NVARCHAR(MAX)

SET @Grade = 8

SET @AppleFlag = 0

SET @PearFlag = 0

SET @BananaFlag = 0

SET @sql...

You want to go for the lowest level of access, so I would create 2 domain accounts one for the SQLServer and one for the SQLAgent, just basic bog standard...

Amsterdam

From this weeks weekly email

http://www.computerworld.com/s/article/9227712/AMD_adds_server_horsepower_with_16_core_chip

SQL2012 License Cost for 1 CPU $109,984.00 or if you get the BL485G8 with 2 chips £219,968.00 😀

Then of course you want to get it with...

this is my take on sample data and a solution

DECLARE @Forum_Posts TABLE (PostID INT IDENTITY, Subject NVARCHAR(100), Body NVARCHAR(100), CreatedDate DATETIME, ThreadID INT)

INSERT INTO @Forum_Posts VALUES ('Sub1','Bod1',GETDATE(),1)

INSERT INTO @Forum_Posts VALUES...

could you provide some sample data and the expected outcome based on that sample data (see the second link in my signature for help should you need it)

Wesley Snipes

bodged together some sample data to match the what the OP has provided so far and a couple of scripts to get the information out but will need more data...

No problem, as I said in the comments as well make sure you pick the right function depending on what your want your ranking column to look like.

I dont think there is in SSRS, but you could change the data set to include the RANK or DENSERANK function depending what you need then show that in the...

Again provide data and table sturctures and we can help you out (see the second link in my signature if you need help)

Knife

Googlewhack