Stored Procedure to pre estimate the table size based on the number of records

Hi,
I need to caliculate the DB size based on the no of records before populating the table with the data.
Is there any stored procedure which will estimate the table size based on the no of records.
I need this for SQL 2005 and 2008.
Thanks in advance.

Hi,
Thanks for the reply.
i tried the same procedure but its not giving the accurate size values for SQL 2005 and SQL 2008.
Can you please point me to a solution to get the accurate size of the table.
Thanks in advance.

SP_SpaceUsed displays how much data a table is using.It shows results for both the data, as well as the indexes (never forget the index space).You can run it as simply as:exec SP_SPACEUSED 'TableTest1'Now you can get a unit-size per row. For example, if the table has 3000KB for data, and 1500KB for indexes, and you inserted a 100K rows, then the average size per row is: (3000KB + 1500KB) / 100,000. Then, multiple that by however many rows you expect.