Your code will only generate a single email, and you cannot guarantee which one it will be. You need to execute a msdb.dbo.sp_send_dbmail call for each recipient, because each...

SQL Server CALS or Windows Server CALS?

I am fairly sure for both the answer is NO you don't. Express doesn't require CALS regardless of authentication type. But you...

Short answer, you can't. At least not out of the box.

The important sentence:

"The SMTP connection manager supports only anonymous authentication and Windows Authentication. It does not support basic authentication."

http://msdn.microsoft.com/en-us/library/ms137684.aspx

You...

Pete,

I have to challenge a number of things in your post.

The biggest problem with security is apathy and lazyness. FAR too many people use highly privileged accounts for app...

I partially agree..

I don't wrap xp_cmdshell at all, I instantiate a process directly, this also means I can control security context. If you wrap xp_cmdshell in a sproc you...

When the only option I had was xp_cmdshell it was a godsend, however when SQL 2005/2008 came available we moved away from its use because of security considerations. We...

I can think of a couple reasons, the first one is an organization with dozens of SQL servers, the CAL is applicable to ANY SQL server of the version it...

So you have a policy of how much free space is within the file, that may be fine for files that have a fair amount of changes but I like...

I'm curious what value you receive from "data file free space" as opposed to something like disk volume free space.

CEWII

With the tools AS PROVIDED you can't access anything in other scripts or containers.

With that said you could maybe do it with either a custom control-flow or data-flow task.

As far...

Based on the object model and how the script is instantiated I would say you can't.

CEWII

Glad you figured it out, I was plain out of ideas..

CEWII

The reality of the IT world often changes these things. There are a great number of cases where it is just as unpalatable to use windows security. I...

I'm not aware of a switch either.

The only thing I can think of is the most obvious to check. The file does exist with that name..

You have checked everything...

Yes, in SSIS it is just as I described.

CEWII