Yeah, you could just write some VBScript and use it in a DTS package to move and re-name the file.  That's the route that I would go.  Thanks.

Chris

Carolyn, your image didn't show.  Can you please re-post?  Thanks.

Chris

Thank you for the wonderful explanation, Karl.

In our shop, we work as DBAs, database developers and applications developers. There are two of us who perform this job.Our IT department is pretty small (about 12 people, mostly...

Thanks, Karl.

Thanks for the reply, Steve.  Do you have certifications?  I heard that they bump you up quite a bit.  True?

If you have log-shipping in place, to maintain a warm stand-by, when should you implement the transfer of log-ins from the primary server to the secondary server?  Can you wait...

Pam, once you move the data into the warehouse, then you've got to use MDX to query that data, right?  Is it worth it?  That's a lot of work!  Setting...

There's also DTS to export to a text file.

How large are your back-up files (just curious)?  Wasn't there some thread of not compressing back-up files?  Is this a non-issue now?

Thanks...Chris

sp_MShasdbaccess

Or, if you are using QA, you can set this option under the "Query" menu item.  Thanks.

Chris

I've encountered my first main problem with maintenance plans.  The optimization part is now failing because I added a database which has a table with a computed column.  I understand that...

Thanks for the heads up, Chris.

Thanks, SR!