Ah. In that case, you shouldn't have...

Gags,

Please elaborate. What do you mean "fixed it the same way"?

What precisely did you do to fix the index=0 issue to allow the datafile to grow, please?

Okay. This is different from what I thought you were doing.

Check the plan history. Any errors or informational messages regarding the email part?

Lee,

I just caught up to the fact that you're using SQL 2000. You need to repost this in that forum. However, you can still use Temp Tables (look them up...

Lee, according to your pseudo-code in the OP, you're calling at least 4 different stored procedures. That's not really containing everything in...

ACK! let me rephrase.

I'm suggesting you use the DDL trigger to update the staging table. Then use a normal T-SQL SELECT within a job to get the staged data and...

What Jack said. I'm not suggesting a Trigger at all. In fact, I strongly urge you not to use a trigger. Triggers play merry heck with the database processing power.

A...

Slam? I didn't mean to slam. Sorry if you took offense at my reply.

Roy is correct about the procs, though. What you've got will work, but it'll be heck on...

Lee,

I think they do, but don't take our word for it. Stick in a dummy proc in your GOTO that creates some fake data, then stick another dummy proc in...

Okay. DB Maintenance plans are created as SSIS packages, so that explains the error format.

More questions & some suggestions.

Do you have any third party software installed for backing up your...

Kevin,

Can you give us the details of the job step that sends out the mail and is supposed to include the attachment? Things like Step Type, the database it's running...

BOL (Books Online) is also a good resource.

I'm pretty sure that backing up a standby database is not really any different from backing up a regular database.

I have rarely seen stored procedures that call other stored procedures. Mostly they call functions.

Have you tested your Exec statements yet? Your pseudo-code looks basically correct.

Another suggestion is to look at the DBA cert books. Not to study for an exam, but because some of the better cert books give you detail by detail how...

I can't count the number of times that a wrong phrase in Google had me chasing ghosts. @=)

Glad I could help. And thank you for posting your resolution. That should...