I'm very pleased to report that your suggestion is working. 😀

Thanks Gail, Luke and The_SQL_DBA.

I find that before I run the stored procedure, if I do these things:

1. shrink...

Hi,

I unattached the database and renamed the log file to something else. Then I reattached the database. This created a new log file.

With the new log file I...

wow, this is a tremendous help. Thanks!!

I should clarify. I'm familiar with this command:

select * from master.sys.backup_devices

This returns the physical_name of the device. However, i'm trying to obtain the contents (e.g., myDBFile.MDF) of the...

Tommy,

Thanks again for the help. You helped us find the link to the DTS runtime. We didn't see it initially.

We have successfully installed the DTS runtime and the...

Hi Tommy,

Thanks very much for the quick reply. We've already installed the DTS Designer Components from this web page. However, we still got the error that I described...

yes, i'm familiar with Microsoft's suggestions regarding naming conventions. It seems like they waited until there were millions of databases out there where developers named their procs "sp_" before...

PW, it worked!

I really appreciate your response. I also appreciate the responses from everyone else.

(Sorry i disappeared for a few days. I got taken off my task...

I have tried that. Another variation i've tried is similiar...