So here’s the deal. We have a lot of reports at my place of employment. Some reports are exact copies of each other with the exception of a few columns. When users request a new report to be built, we can generally direct them to one of these reports. For our (searching) purposes this can be a bit laborious because we have to open the report to see the SQL so that we can see the columns that are being pulled to see if the columns/data points are what the users are looking for. I figured an easier way of doing this was to search the SQL Server reporting database (from now on referred to as its proper name ReportServer) for column names. I’ll walk through the code here. To start off, I created some variables because I’ll need to do some additional processing in a variable table: DECLARE @t TABLE ( eye_d INT IDENTITY ( 1 , 1 ), ItemID UNIQUEIDENTIFIER , Name VARCHAR ( 500 ), Type INT , typedescription VARCHAR ( 100 ), content IMAG...