Using SQL 2008 - Beginner - Is there a way to find the source to the standard reports? When I right click on a database name then click reports then click standard reports I see a whole list of reports, such as Disk Usage, etc. Any way to see the rdl on those reports? If so where do I find them? Your help is greatly appreciated.

Hi, You can get all the reports here http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Components-PostAttachments/00-00-73-29-10/SSMS-Standard-Reports.zip

Thank you so much - I really appreciate the help

Downloaded the zip. unzipped to a project. Attempted to run disk_usage.rdl and received this error: query action failed for dataset RightPanel05 Incorrect syntax near ';' I can't seem to find what needs changing. Didn't change any of the original source. Here is original code for RightPanel05. Any help is greatly appreciated. = " begin try use [" & Parameters!DatabaseName.Value & "] ; declare @table_name varchar(500) ; declare @schema_name varchar(500) ; declare @tab1 table( tablename varchar (500) collate database_default , schemaname varchar(500) collate database_default ); declare @temp_table table ( tablename sysname , row_count int , reserved varchar(50) collate database_default , data varchar(50) collate database_default , index_size varchar(50) collate database_default , unused varchar(50) collate database_default ); insert into @tab1 select t1.name , t2.name from sys.tables t1 inner join sys.schemas t2 on ( t1.schema_id = t2.schema_id ); declare c1 cursor for select t2.name + '.' + t1.name from sys.tables t1 inner join sys.schemas t2 on ( t1.schema_id = t2.schema_id ); open c1; fetch NEXT from c1 into @table_name; while @@FETCH_STATUS = 0 begin set @table_name = replace(@table_name, '[',''); set @table_name = replace(@table_name, ']',''); -- make sure the object exists before calling sp_spacedused if exists(SELECT object_id FROM sys.objects WHERE object_id = object_id(@table_name)) begin insert into @temp_table exec sp_spaceused @table_name, false ; end fetch NEXT from c1 into @table_name; end; close c1; deallocate c1; select (row_number() over(order by t2.schemaname,t2.tablename))%2 as l1 , t1.* , t2.schemaname from @temp_table t1 inner join @tab1 t2 on (t1.tablename = t2.tablename ) order by schemaname,tablename; end try begin catch select -100 as l1 , ERROR_NUMBER() as tablename , ERROR_SEVERITY() as row_count , ERROR_STATE() as reserved , ERROR_MESSAGE() as data , 1 as index_size, 1 as unused, 1 as schemaname end catch "

Hi RudyCat, I was getting same error message for report "Disk Usage.rdl" file. I modified most of the DataSet by comments first, thrid & last line of each dataset code. Also I modified dataset "RightPanel06" based Table "Disk Space Used by Partitions" by changing expression something like this:- "ADDED PLUS SYMBOL to get rid of error message" =IIF(Fields!index_id.Value = 0,"Table" ,"Index ({0})"+(Fields!name_1.Value) ) Now everything works perfectly for me as expected. Please do let us know if you have any more issues with the smae. Thanks KumarKG, MCTS

Thanks Kumar - looks like that took care of it.

Hi RudyCat, You have to marked the answered Correctly. Please mark the correct response not just irrelevant responses, this helps outhers too for their better understandings. Thankss; KumarKG, MCTS