You must use SSMS for SQL 2005 at least. If you don't use SQL 2008, you will not have any of the wonderful benefits in SSMS, SSIS, SSRS, etc.... You...

You cannot use text as a comparison. Keep the datatime data type. You are converting that to text, SQL cannot use text in a greater than or less than.

Also, remove...

The question that I have is this:

Why in the world would a developer be allowed to create a backup, or to restore a database from a backup?

A developer should have...

What I have found, is that you must have SQL Server Service running under a non-human AD account, or create a non-human account on each of the two boxes. Then...

Thanks any way, I found a really great random text generator for SQL. This will create all kinds of junk text,

Just change the @Length variable for the length of...

Since you said that you have only the one account, I would just re-create it by hand. Much more simple for only the one account.

You will have the original database...

Never a good idea to use old fashioned, non-secure batch files. That is just awful. How are you calling other stored procedures? I suggest that you use something other than...

Not when you take a backup. Nothing has to be stopped, and no user has to exit. Just create a Full backup and move the backup file to where ever...

I would recommend using Backup and Restore. Much easier and if something is incorrect, you still have the original database up and running. Also, how do you plan to transfer...

You could write a stored procedure and call that sproc from within your SSIS package. You could simply add that step the an existing package, like the one that you...

No, but you can easily change the input parameter to a varchar, so that it will expect a name instead of an ID.

Andrew SQLDBA

No, you would want to un-install the Express edition first, do not try to "upgrade". That is the very best way to approach this issue.

You can create a backup of...

Very, Very Poor design. Your database will many empty rows. What happens when you insert a new blank record just to get SQL to create an ID, and then the...

I strongly suggest that you not even bother with Express. Just in stall Standard Edition and be done. There is actually no "Upgrade" from Express to any other version. You...

Use the SQL Book Online, much better, much lighter weight, and the other thing......

Oh yea, Free.

You should not allow someone else to install SQL for you. How do you know...