The following update query should do what you want:

update dbo.IMG_WHOLE_BRAIN

   set Scan_Date = MRI.Exam_DATE_stamp

   from dbo.IMG_WHOLE_BRAIN as IWB

   join dbo.mrisession      as MRI

     on IWB.Subj_Num = MRI.Subj_Num   and

        IWB.Magnet_strength_in_gauss =...

Janice

   Money is just a decimal field with 4 automatic decimal places.  Of course when you use it with Americano Dollars you should only use the first two decimal place.

 ...

Merrily

  Yes your full backups (dumps) are good to restore the database to the point in time when the database dump completed.

  Yes you are correct.  If you never take log...

  You do not need to be logged onto the server with the account that SQL server uses.  The logical drives during the SP_ATTACH_DB will be taken with respect to the account that SQL...

I am using both an AMD 64 / 3200 processor and a Intel process (both running 32 bit operating systems) to test the SQL 2005 product.

So far I have found...

We experienced many performance problems trying to use the maintenance plans.

What we ended up doing was to have a SQL agent job that had a step for each database (you...

The following command should work assuming that the database was named test11_db previously and that the stated files are present (Based on logical drives on your SQL server).  

EXEC sp_attach_db...

I had this problem when I installed both Report Server and Sharepoint Services on the same server.

I believe that Steve's reponse is correct.  Look up "RSACTIVATE" for how to manually...

Paula

When you run your log dumps are they serially threaded.  If you try to run log dumps against all databases on your server at exactly 12:00 noon they will all...

We used UNC network shares \\ServerName\LogDumps.

The Share was an Compaq RAID-5 array sitting on our primary server (The production databases were on EMC Clarion SAN).

The log dumps that came...

Do you have access to any other disk?

Your protection is not very good if you are backing up the transaction logs to the same disk arrays that the databases...

I used the retry successfully to wait until I could receive exclusive access to needed files.

This is very similar to what you are doing.

I don't expect that you would...

This should work fine.  When you get to the output columns screen by double clicking you can obtain access to change the output column to a DateTime Format.

When I run...

I am assuming that these are your production OLTP databases.

The problem with having any "ad-hoc" access to these databases is that they may interfere with the performance and stability of...