Posted - March 04 2010 : 20:38:10
| This addon is only relevant if your site uses SQLServer.
If you are using SQLServer, and you've got customised columns (or have lengthened existing columns), or you want to know how much spare space you've got until you hit the 8k limit, then this is going to save you a whole load of headaches:
BYZ120 - Table Size Calculator for SQLServer
It's generic asp; doesn't matter what version of VPASP you're using (or which version of SQLServer you're using), doesn't even matter if you don't have VPASP; as long as your server/site runs asp files then this'll work.
I particularly like the fact that it's so easy to install, don't need to do anything at all with any of your vpasp files, just edit the configuration file in notepad and then upload the files to your site.
What's the 8k bug all about, some people might wonder? Take a look at this page which explains it:
NOTE: The 8k bug is not a vpasp bug, it's a generic sqlserver bug, and if you have default vpasp then the bug doesn't effect you, it'll only effect you if you've changed the table definitions from the default. As far as I know, default vpasp deals with all the SQLServer bugs without any problems, it's only when you change your table definitions that you're potentially running into problems.
This module's been in our "ready-for-packaging" pile for years, but with the release of vpasp v7 (ie more tables, and more columns), we thought it was about time we finally packaged it up, spruced it up a bit, and started letting other people use it. It's saved us a huge amount of time/hassle in the past, so I hope that some vpasp sqlserver merchants who've tweaked their tables (or are thinking of tweaking their tables) find it as useful as we do.
Follow us on Twitter: http://twitter.com/bigyellowzone
Web Design, Online Marketing and VPASP addons