• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 429
  • Last Modified:

Getting the sp_spaceused all on one line

Trying to get all this information on one line

Servername  database(mb), database size(mb), unallocated(mb), reservered data(kb), data(kb),index size(kb)      unused(kb), space available(mb), actual size of ldf,  actual size of mdf,  total ldf + mdf (mb)

But if i run the sp_spaceused get two rows of data.

Doing it manually for now...
0
TRACEYMARY
Asked:
TRACEYMARY
  • 2
1 Solution
 
EMCITCommented:
Servername  database(mb), database size(mb), unallocated(mb), reservered data(kb), data(kb),index size(kb),     unused(kb), space available(mb), actual size of ldf,  actual size of mdf,  total ldf + mdf (mb)

0
 
imrancsCommented:
Go to master database, copy the script of sp_spaceused and make a new procedure using the script of the sp_spaceused and you need to make a few changes and you can get the result in one row.

Imran
0
 
imrancsCommented:
Glad I could help.

Imran
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now