HELP

I am using SQL server 2005, and I am having trouble while copying database from Local to Server.

Here are the things I had tried so far.

1. Copy database option from task menu.




1. Getting error message


2. Tried the Generate Script method.




1. Copied most of the objects but not all.


3. Tried the backup and restore method.




1. No luck


4. Tried Google Search

( Server : SQL Server 9.0.1406 – sa

Local: SQL Server 9.0.1399 – sa ) Does this matter????

SQL Server is working fine on both local and server.

Please suggest.  need to keep job and pay bills