Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine Current Disk Usage

Status
Not open for further replies.
davewelsh

davewelsh

Programmer
Jun 26, 2001
71
CA
My hosting company has a quota in place for my MS SQL server (SQL Server 2000 I think). I wanted to write a script in ASP that would determine how much space is currently being used in my database so I could tell if I need to buy more storage or clear some rows.

Are there any SQL commands that could help me out with that?
 
Sort by date Sort by votes
I saw in the FAQ that you can use something like
Code: 
exec sp_spaceused <tablename>
But I don't know how to use that with ASP/ADO.
 
Upvote 0 Downvote
Execute that stored procedure as you would any other stored procedure. Are you using ASP or ASP.NET?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
1K
gmmastros
gmmastros
ahmedsa2018
  • Locked
  • Question
How to get monther per part id from last date to current date and include remaining date ? 1
Replies
7
Views
446
JohnBayne
JohnBayne
barim
  • Locked
  • Question
Compare Dates With Current Date
Replies
3
Views
218
barim
barim
Auguy
  • Locked
  • Question
Delete Trigger Usage and Options 1
Replies
5
Views
434
Auguy
Auguy
grnzbra
  • Locked
  • Question
Determine Table Columns Associated with View Columns
Replies
4
Views
220
iambob
iambob

Part and Inventory Search

Sponsor

Back
Top