sp_spaceused of a temporary table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

sp_spaceused of a temporary table

Author

Topic

Lijo Cheeran Joseph
Posting Yak Master

123 Posts

Posted - 2010-03-13 : 06:10:57

Hi Team,

I am trying to view the space used by indexes on a temporary table. How can I see it?

When I used the following, it resulted in error.

CREATE TABLE #Transfer
(
[TransferID] [int] IDENTITY(1,1) NOT NULL,
[FundingID] [int],
[Agent] [varchar](50) NOT NULL,
CONSTRAINT [PK_Trans_TransferID] PRIMARY KEY CLUSTERED ([TransferID] ASC)
) ON [PRIMARY]

UPDATE STATISTICS #Transfer;
GO

sp_spaceused #Transfer

-- The object '#Transfer' does not exist in database 'XXX.08' or is invalid for this operation.

Please help

Thanks
Lijo Cheeran Joseph

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-13 : 08:09:38

Try this


CREATE TABLE #Transfer
(
[TransferID] [int] IDENTITY(1,1) NOT NULL,
[FundingID] [int],
[Agent] [varchar](50) NOT NULL,
CONSTRAINT [PK_Trans_TransferID] PRIMARY KEY CLUSTERED ([TransferID] ASC)
) ON [PRIMARY]

UPDATE STATISTICS #Transfer;
GO

Use TempDB
sp_spaceused #Transfer

Vaibhav T

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-13 : 08:13:23

quote:

Originally posted by vaibhavktiwari83

Try this


CREATE TABLE #Transfer
(
[TransferID] [int] IDENTITY(1,1) NOT NULL,
[FundingID] [int],
[Agent] [varchar](50) NOT NULL,
CONSTRAINT [PK_Trans_TransferID] PRIMARY KEY CLUSTERED ([TransferID] ASC)
) ON [PRIMARY]

UPDATE STATISTICS #Transfer;
GO

Use TempDB
GO 
sp_spaceused #Transfer
GO

Vaibhav T

little change in red

Vaibhav T

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources