Hello,
I need to get database space space usage information into one table and then
format the output in one report.
Im using the sp_spaceused stored procedure to get this information but
because it sends the output separate in two blocks i cant insert it into one
table.
I send you what im doing but it doesnt function.
create table dbsize
(
database_name varchar(128),
database_size varchar(18),
[unallocated space] varchar(18),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18)
)
insert into dbsize exec sp_spaceused
Can you help me?
Thanks and best regardsYou could try gathering the information you need from the system tables.
-Argenis
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:796CCE66-1418-4072-9DFA-3AD3F63E95DF@.microsoft.com...
> Hello,
> I need to get database space space usage information into one table and
then
> format the output in one report.
> Im using the sp_spaceused stored procedure to get this information but
> because it sends the output separate in two blocks i cant insert it into
one
> table.
> I send you what im doing but it doesnt function.
> create table dbsize
> (
> database_name varchar(128),
> database_size varchar(18),
> [unallocated space] varchar(18),
> reserved varchar(18),
> data varchar(18),
> index_size varchar(18),
> unused varchar(18)
> )
> insert into dbsize exec sp_spaceused
> Can you help me?
> Thanks and best regards
No comments:
Post a Comment