Yes, lookup Restore in BOL (Books on line) and there is an example. You basically use a different database name and the with MOVE property.

Like:

Restore Database NewDBName From...

Something I think needs to be asked, source is different in all the rows, why doesn't this matter? The data was stored for some reason originally, do you...

Since you are restoring from a file that contains multiple backups you need to reference the file number in the backup file. Like this:

Restore Log database_name From Disk=FilePath With...

Don't you mean for the last record you would want the record with unique Id 4?

Robert,

I'm gald we got this sorted out. I didn't go in trying to prove anything only to understand how it works.

Robert,

Using RaisError the way you use it in your example is generating an error message for the client, but is not actually an error in the trigger which is why...

I don't know that I'd call a trigger excessive because of the number of lines of code, but more by what it does and how long it takes. I...

Connections to the SQL Server or the web server(s)? You do not want the log and data files on the same drive so don't move them.

What does the CDT stand for? Are there other values besides CDT in the middle of the time and date?

Okay with that data all you need is a Group By and a Max(PurchaseDate)

Select

product_id,

product_name,

Max(purchase_date) as last_purchase_date

From

...

There is no such thing as an evet_date date type in SQL Server. It could be a user defined type and then you need to let me know what...

Okay, you should take a look at the links in my signature line as posting a more complete question helps you get better answers.

When you say you get multiple rows...

If you have SSIS 2005 then you can develop your packages in it with SQL Server 2000 as either a source or a destination and as long as you do...

What are your rules for determining if a row is a duplicate?

What is the data type of the event_tim column? Do I need to find the time difference between row 1 and row 2 in order to get the time...