Are you not specifically indicating what size the new DB will be?  What does your CREATE Database statement look like?

If you are using a command to create the database, please post this.  If using EM are you sure that the location specified on the Transaction log tab and the...

You da man..   Wow and to think they were paid to put that together.  It seems like some people had a lot of fun. 

SQL on your workstation?  hmm Its not SQL Server personal edition is it? This may casue issues with connections.

Dooh !!

Easily done see http://www.sqlservercentral.com/scripts/contributions/25.asp

If you want to defragment the physical DB MDF or LDF file use sysinternals CONTIG program http://www.sysinternals.com/Utilities/Contig.html

I usually schedule a SQL job for this during slow times, But frankly...

I may have been too hasty here.  Try something like:  SELECT P.PROJECTNUM,

                P.PO,

                P.Region,

                P.Customer,

                P.CustomerContact,

                P.Location,

                P.LocationContact,

                P.Project_Loc_Phone,

                P.AUTHORIZATIONFORMSENT,

                E.Area_Code,

                E.ADDRESS_STRING,

                P.Project_Loc_Contact1_ID

FROM Project_Info_vu P

LEFT JOIN...

I conceed Noel.  The repeated use of MAX isn't right.  Your query is better.

Which record?  There are several records where job_lvl = 35.  If you just want the one where all the fields other than the job_lvl are alphabetically the largest you could...

You are getting what you asked for.  If for example your project table contains in part:

Customer_Contact_ID    Customer    Location   Region                 PO

1                                IBM            US         NorthAmerica           2

2                                Apple          UK         Europe                   4

ELECTRONIC_ADDRESS

Customer_Contact_ID  ...

If you can connect to both machines. copy the backup to your workstation, then copy it again to the destination server

You may have already discovered this but you should be able to store English characters in the unicode columns.  Unicode gives you the option of storing unicode data.  If you...

Sorry, as mentioned before the truncate log option removes entries from the log when a checkpoint occurs (such as the end of your DTS job)  Production database should have truncate...

The problem is likely SP2 (without looking at the logs I can't be sure)  SP2 does not play nicely with SQL unless certain things are done.  It all has to...