Check Table Size and DB Size

Question

Post reply

Check Table Size and DB Size

Kenneth Igiri

SSCertifiable

Points: 5018
More actions
March 3, 2012 at 3:17 pm

#391716

Comments posted to this topic are about the item Check Table Size and DB Size
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

lup328 SSC-Addicted Points: 477 More actions · Answer 1

While running the code to check the table size, I got this error:

'Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62

The object '[dbo].[#0035E158]' does not exist in database 'tempdb' or is invalid for this operation.

Kenneth Igiri SSCertifiable Points: 5018 More actions · Answer 2

Which of th scripts did you have this error with? Check DB Size or CHeck Table Size.

Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising

Kenneth Igiri SSCertifiable Points: 5018 More actions · Answer 3

Apparently yo had this error with the Check table Size script:

use AcsData

go

create table #tablesize

(name nvarchar(120),rows char(11),reserved varchar(18),

data varchar(18),index_size varchar(18),unused varchar(18))

go

insert into #tablesize

exec

sp_msforeachtable @command1=

'exec sp_spaceused ''?'''

select * from #tablesize

go

drop table #tablesize

go

You need to replace the <DB_NAME> line with an actual database. Apparently you ran the script on tempdb and objects are created and droped in this db onthe fly.

Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising