Hi,

I believe this is what you are looking for.

USE

GO

CREATE TABLE #temp (

table_name sysname ,

row_count INT,

reserved_size VARCHAR(50),

data_size VARCHAR(50),

index_size VARCHAR(50),

unused_size VARCHAR(50))

SET NOCOUNT ON

INSERT #temp

EXEC sp_msforeachtable 'sp_spaceused ''?'''

SELECT a.table_name,

a.row_count,

COUNT(*) AS col_count,

a.data_size

FROM #temp...

Hi,

Please run below steps on your test database.

create table test (col1 int primary key, col2 varchar(10) )

insert into test values(1,'col1')

insert into test values(2,'col2')

insert into test values(3,'col3')

insert into test values(4,'col4')

select *...

Below Scripts are captured by running Profiler at the back end and then by running SQL 2005 Performance Dash Board Tool.

Top CPU

**********

exec sp_executesql @stmt=N'select

query_rank,

charted_value,

master.dbo.fn_varbintohexstr(sql_handle) as sql_handle,

master.dbo.fn_varbintohexstr(plan_handle) as plan_handle,

statement_start_offset,

statement_end_offset,

creation_time,

last_execution_time,

execution_count,

plan_generation_num,

total_worker_time,

last_worker_time,

min_worker_time,

max_worker_time,

total_physical_reads,

last_physical_reads,

min_physical_reads,

max_physical_reads,

total_logical_reads,

last_logical_reads,

min_logical_reads,

max_logical_reads,

total_logical_writes,

last_logical_writes,

min_logical_writes,

max_logical_writes,

total_clr_time,

last_clr_time,

min_clr_time,

max_clr_time,

total_elapsed_time,

last_elapsed_time,

min_elapsed_time,

max_elapsed_time,

case...

Hi,

Please let us know at what step we are getting this error. Is it when some Agent try to start at that point and will it be possible to collect...

Hi,

Sys.sysservers is a internal table. We will not be able to find it either in MSDB or MASTER database.

If I am not wrong it is similar to one of those...

Hi,

You can create this task using below command as well.

sp_MSForEachTable @command1='Update Statistics ? with FULLSCAN'

It will Update Statistics with Full Scan.

Regards

Gurpreet Sethi

Hi Kiran,

A.J. is right. The method which A.J. metioned is good. There is another method which is mentioned at below blog.

http://blogs.msdn.com/mariae/archive/2009/04/01/reporting-services-resilience-recommendations.aspx

Regards

Gurpreet Sethi