Check the Microsoft site for SQLH2, it's free.

As has been explained in the several other threads you have posted, all that msdb.dbo.sp_start_job does is start a job.  It returns...

I would use dynamic sql.  Build the approriate sql statement(s) as need based on the version of SQL Server that is being used, then execute that script using exec or...

Not enough information to diagnos the error message on the failed transaction log backup.  How is the backup device setup?  Is it on a network share?  If so, it is...

Are you missing a transactioon log backup.  The original error message you received indicated that there was an earlier transaction log backup than the one you tried to restore.

That, of course, requires that you Office (Excel) installed on your server.  I personally try to keep office of my SQL server systems as much as possible.  Using CLR, there...

The simplest query is:

select * from msdb.dbo.backupset where backup_start_date between <earliest datetime> and <latest datetime>

What information is available in the msdb.dbo.backupset table for the day in question?

If LineNumber is used, it has to be included with the OrderNumber to make it unique.  Also, based on experience, I have worked on some systems written in Fortran and...

It depends.  What are your requirements?  Out of the box, SSIS can not detect changes between databases.  You will have to write the process to identify changes and to move...

I started to ask you to explain why the difference, but I just figured it out, the addition in DATEADD is not communitive.  0 + 107 != 107 + 0. ...

select dateadd(dd, 0, datediff(dd, 0, getdate()))

If you are still have a problem with the restore, have you checked the SQL Logs or msdb.dbo.backupset table to see if there is a missing transaction log backup?

Look at sys.indexes.

Pardon me for this, but I am practicing to be a consultant: It depends.  Since you are using an identity field in the OrderDetail table, the LineNumber column could be...