I would do it before users get on the system.  After you switch to full recovery mode, do a full backup and then start your transaction log process to start...

Also, convert your data from int to float before using and that you aren't passing the log10 function a 0 (zero) value.

LOG in Excel defaults to base 10, where as LOG in SQL is the Natural Logarithm  (same as ln in Excel) of a number.  In SQL you need to use LOG10.

hth

Here is my suggestion without looking at the data, import the data into a temporary table as text (character data), then convert it as you move it to your database. ...

Yes

I agree with Aaron if you are going to keep your database in 3NF.  Again, however, I'd also still say "It depends".  Yes you can keep the database in 3NF,...

Or try this:

select

    MAIN_CODE,

    SUB_CODE,

    NAME,

    DAYS = (select

                INTVALUE

            from

                PINF p2

                right outer join PINF p3

                    on (p2.MAIN_CODE =* p3.MAIN_CODE

                        and p2.SUB_CODE = p3.SUB_CODE

                        and p2.NAME = 'DAYS'))

from

   ...

How about showing us the code you wrote in 2005?

Also, you can query msdb.dbo.backupset to see what backups were completed if you don't have access to the logs for the time in question.

It appears that there my have been a truncate of the log file done between the differential backup (file 3) and the next transaction log backup (file 4).

I am guessing...

If the scripts above are accurate, I don't see you using the NORECOVERY option while restoring the differential backup.

Also, what happens if you restore the full backup (file 1) and...

I have gone back through my posts and have found four threads for this same procedure.

I really can't stress enough that you need to try to solve your problems first...

As a consultant would say: It depends.  If some columns are accessed or updated more frequently than others, it may make sense to vertically partition the table.  It really comes...

Never had a reason to do what you are trying to do.  When I started a job with sp_start_job, that was all I was interested indoing as I was doing...

I know I am getting old, but this looks like your asking the same question again.  After you start the job using sp_start_job, you will need to loop inside your...