Sort out MS SQL db so aspx website will work

We've moving an .aspx site to our servers. We have a zip of the site files and a .bak of the db. We've uploaded the site files and restored the db from the .bak.

Initially nothing worked because none of the stored procedures had been copied across during the restore. I scripted all the stored procedures and copied them to the live db.

Then a few functions wouldn't work because during the restore no columns were set to autoincrement, so I rescripted all the tables and rebuilt the tables on the live server. Then did the same again to copy the data across to the live server.

Now we still have an image drawing/showing function where we are getting an

"URI formats are not supported" error

and a number of save to db functions where we are getting

"The conversion of a varchar data type to a datetime data type resulted in an out-of-range value"


I believe the code is in order and the problem is in the db. I think these errors are coming from variables being mis-cast, probably the regional settings on the db are incorrect or something so the date is in the correct format but the db is wrongly expecting it in a different format.

We need someone who knows MS SQL to fix this quickly and simply.

Either by simply uploading/restoring the correct, complete db to the live server from the .bak or by knowing where and how to affect the regional settings.

The live server uses a Microsoft SQL Server 2008 database.

You can connect to this database using SQL Server Management Studio 2008. Please ensure you have this before bidding.

Many thanks.

Habilidades: ASP, SQL

Ver mais: sort database sql, sort sql, website procedures, website formats, website errors fix, value website, this website will, sql data conversion, sort function c, microsoft fix it website, fix website restore error, fix i-5 website, data conversion sql, c sort function, t-sql in, website studio, microsoft website, uploading website, t-sql;, stored procedures, sql, sql microsoft, Sql code, sql c, OUT

Acerca do Empregador:
( 31 comentários ) London, United Kingdom

ID do Projeto: #538822

Premiar a:


Helo please see PMB

$150 USD em 0 dias
(31 Avaliações)

8 freelancers are bidding on average $132 for this job


have a glance at PM. Regards,

$246 USD in 6 dias
(173 Comentários)

Can I have access to old MS SQL database? I will backup it in my way and restore on new server. Next - I will run your ASPX code and check all database-related errors. I need FTP access and access to MS SQL Server.

$100 USD in 2 dias
(446 Comentários)

Hello, Expert Computer Engineer, in,,C#, Sql2008, Can Start Work on Immediately effect. Thanx

$100 USD em 1 dia
(8 Comentários)

I am interested in working on your project. I have 3 year experience in web application. I took part around all the aspects of software engineering Analyses, Design , Database design, Coding in both backend an Mais

$100 USD in 3 dias
(9 Comentários)

Hi check Pm Please Thanks

$60 USD in 2 dias
(1 Comentário)

Please see PM for more details.

$200 USD in 0 dias
(0 Comentários)

Have worked with SQL server 2008 on ASP sites.

$100 USD in 2 dias
(0 Comentários)