[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

Estmating database size

apparently, there is a procedure called sp_estspace and there is a microsoft version of it called estspace.sql which guides one through size estimation for a new database. could someone happen to know as to how to get it??
0
sajalk
Asked:
sajalk
  • 2
1 Solution
 
mitekCommented:
Not in MS SQL 6.5. Are you talking about 7.0 ?
0
 
sajalkAuthor Commented:
i read about this in a book, and it is for 6.5. the sp_estspace procedure is the sybase version.
i would send a mail to the author to get some more informaion on it.

thanx much.
sajal.
0
 
connexCommented:
There is no such sql-file I know of. Never heard of it though.
But there is a good article in the SQL Server Ressource Guide
about Estimating Database Sizes.
(Head to support.mircosoft.com and search for
 "estimating database size sql")


0
 
sajalkAuthor Commented:
i have found it.

thanx very much.
sajal.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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