-
estimation
I want to estimate the amount of space needed to bcp a table to a file. When I use sp_spaceused {tablename} it gives me a pretty aproxiate amount of space. I have done this with a couple of tables which are not so big. The amount given by sp_spaceused is real close to the amount taken up by doing the bcp out. But when I use sp_spaceused to a huge table it will give the output as 0k. There is an overflow so it will not give me that info..
Is there an equation that I may use to get real close to the bcp file.
Thank you....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|