CREATE

TABLE #space (

name varchar

(18),rows char(11),reserved varchar

can i use my where clause in your query

like

where datepart(yyyy,convert(char(10),cast(date - 36161 as datetime),101))=1995

I am calculating row length for each table and then summing up for entire DB

I am not sured If i followed you..

does it work if am comapring the backup of database for 1995 and 1996 to estimate the growth.

like comparing backup of 12/31/1995 with...

Total row length for all tables in my DB is 81245

and the row count for all tables in the same DB is 7234, now when i multiply these 2 i...

but still i cudnt replace [ ] for table name.

I need just employees instead of [employees]

can i just have the row size and multiply by no.of rows or shud i also count no.of bytes assigned for each column in a table.

OK Now I got the total no of rows in a database.

Now is there a way to find the space used by my total count.

I got a count of 162345...

I am trying to insert into temp table and sum the total but no luck..any help on that.

row length?

I know the no of rows but how can i find row length for the rows returned from entire DB.

exec

sp_MSforeachtable 'select count(*) as no_of_rows, ''?'' as table_name from ?

where datepart(yyyy,convert(char(10),cast(date - 36161 as datetime),101))=1995'

This query is working fine...

select count(convert(char(10),cast(date - 36161

I want size for the no of rows returned.

if select * from emp where job=5

returns 5023 rows, I want the size of only these rows

I am able to count no of rows for each table for the year 1995 but how can I add all the count in the database ie: for all the...

thanks ripg.. tht works fine but how can i do that for the entire database, most of the tables have the same column.

Actually I want to count the no.of rows...