Michael L John (7/5/2016)

---

dclemens (7/5/2016)

---

I've taken over a production SQL server (2008 R2 Enterprise) and upon doing my checklist I've uncovered that TempDB currently has 4 files (2) 10500MB and...

Here is a query I have in my toolbox that should put you on the right track.

USE ReportServer

GO

;

WITH ReportEmailsInfo

AS (

SELECT S.[SubscriptionID]

,CONVERT(XML, N'<Root>' + CONVERT(NVARCHAR(MAX), S.[ExtensionSettings]) + N'</Root>') AS X

FROM ReportServer.dbo.[Subscriptions]...

unit 527861 should contribute to the sum each month in year 2012 because it has a trc_startdate of12/31/2011 and a trc_retiredate of 12/31/2049

unit 525505 should contribute to the sum for...

Sean Lange (1/23/2013)

---

Your query doesn't produce any results because it has a table called manpowerprofile? If I comment out that table it returns a single value - 26. This is...

ScottPletcher- Thanks for the reply, although the results are not what i'm looking for.

ScottPletcher (1/23/2013)

---

Don't know full details, but the usual outline for such queries is shown below.

SELECT

...

I use this; Run it against the reportserver db.

DECLARE @OldUserID uniqueidentifier

DECLARE @NewUserID uniqueidentifier

SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = '<NewUser/domain>'

SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName =...