Have you created a MAPI profile under the user account which the SQL Server Agent is running? If so, have you set the properties for SQL Server Agent to...

The key here, though, is that you have an app that runs in interactive mode. Anything that runs as a job shouldn't have any components that require user interaction... automated...

Is Autonumber listed as one of your destination columns?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Is your client willing to pay for the support call to Microsoft? I'm sure they've got something...

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

From a security perspective, you are probably okay. However, as I discussed earlier, if you want data manipulation to occur in certain defined ways that are strictly controlled (necessary...

I think the only cases I've implemented dynamic SQL is for sysadmin stored procs and the like. I too am paranoid when it comes to security. Just because...

What error are you receiving?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I try to avoid dynamic SQL whenever possible. Security is one issue, as I've already discussed (we have multi-user apps which have different levels of access) and the performance...

Ouch. I'll keep looking. The bottom line, though gets back to:

quote:

---

the clients back-up strategy leaves a lot to be desired.