I agree with Remi.  Use DTS and do the data conversion en route to the new database.

Greg

Merrily,

Do this after switching to Simple recovery model:

BACKUP LOG database_name WITH TRUNCATE_ONLY

You may need to do a SHRINKFILE also.

Greg

Richard,

Check out this page, http://www.microsoft.com/sql/evaluation/overview/default.asp

and search SQL Server Central for discussions of Enterprise Edition vs. Standard Edition before pushing your boss too hard for Enterprise Edition.  IMHO, your application...

swayzack,

That's exactly how I set up an application recently where users wanted to export data on demand.  My "run request checker" job runs every 10 minutes between 5:00 AM and...

Yes, it's possible.  You can put the backup commands for each database in a separate job step.  See "creating jobs" and "backup log" in BooksOnLine.

Greg

To put together what others have suggested:

If the database is using Full recovery model and you have a full database backup from a point prior to the time when the...

As long as you're using QA, why not just use the Object Browser and save some typing?

Greg

I don't have much experience with this, but here's a couple of cents worth.

1. Consider using an Execute Process task or an Execute SQL task containing xp_cmdshell in DTS to...

Merrily,

As I suggested in your previous thread, if there's no need for point-in-time recovery, change the recovery model to Simple.  You can't actually "remove" the logs, but they'll be truncated...

...or add the user to TargetServersRole in MSDB and grant the role EXECUTE permission to sp_start_job. 

Greg

...or have DTS import to staging tables, then use SQL tasks to do the INSERTs, UPDATEs, and DELETEs.

Greg

When I thought about this a little more, it occured to me that I may have given you a bum steer, Bill.

I don't think the stored procedures actually have anything...

Bill,

Make sure that the Public role has permission to execute the "DTS" stored procedures in MSDB and that guest is a member of Public.

Greg

Can you give some more detail about what you're trying to do?  What's your source and destination?  Does the destination exist? 

I've only seen that message when I've tried to...

Matthew,

If you're using a login other than your own for the connection in DTS, you'll have to grant it access to the database.

If the package is scheduled, it runs under...