Thanks for that, ill take it up with someone. Would you mind marking "This issue has been solved." once your dba has done it and its resolved your issue :)
I ran the deployment scanner before upgrading our test lab from 7.5 SP5 to 8 SP1 and it did include the URL. I saved it because I had sent it off to our DBA to review.
SQL Collation
Failed
At least one test for the SQL server collation has failed. SQL databases (shown below) contain entities with mixed collations. If they are Enterprise Vault Vault Store databases then they will prevent a successful upgrade. Please go to http://seer.entsupport.symantec.com/docs/293475.htm for more details.