VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Add-ons for VP-ASP
 Table Size Calculator for SQLServer (8k bug check)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Senior Member

United Kingdom
1898 Posts

Posted - March 04 2010 :  20:38:10  Show Profile  Visit devshb's Homepage  Reply with Quote
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.

Simon Barnaby
[email protected]
Follow us on Twitter: http://twitter.com/bigyellowzone
Web Design, Online Marketing and VPASP addons
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000