Monthly Archives: October 2011

Finding SQL Server’s Full-Text indexes

I have a lot of servers.  Full-Text operations sort of slipped up on me.  Then, a developer asked for assistance…in particular who else was using full-text that he could ask for guidance?  I couldn’t tell him.  That got me started … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration | Tagged | Leave a comment

SSRS Report History – keep more than 60 days

Many may know that the following query can get information about the history of reports being called. SELECT ss.UserName, ss.Format, ss.TimeStart, cat.Name, ss.Parameters, CONVERT(nvarchar(10), ss.TimeStart, 101) AS rundate FROM reportServer.dbo.ExecutionLog AS ss INNER JOIN Catalog AS cat ON ss.ReportID = … Continue reading

Posted in SSRS | Tagged | 1 Comment