That happens when you change the db owner.

What does this return:

SELECT SUSER_SNAME(owner_sid)

FROM sys.databases

WHERE name = 'yourDatabase';

I think you'll find that it returns CUSTOMERCARE\dscott,...

bwperrin (8/20/2012)

---

Yes, I did the following from a SQL Agent PowerShell job step:

$src = "\\serverpath\filename"

$dst = "e:\path\filename"

Copy-item $src -destination $dst

and still...

Things are not adding up. Can you post a screenshot of what you're seeing?

OK, that is what it should be. Nothing to be concerned about. Since...

Hello Tony, thanks for reading my article. I'll say this, in just starting out with SSIS you have a lot of ramping up to do. You'll need to cover not...

Thanks for posting back. Could you post the code that worked for you? Personally I am curious to see what finally worked but maybe others can benefit too.

mtassin (8/17/2012)

---

I'm working with this.... I have a question

So I'm trying to watch for new files... when I see one I kick into a For Each Loop Container that processes...

Are you sure? For the record:

If they have...

If you're looking for LPIM on a 32-bit system enable AWE (applies to all 32-bit systems, even ones with < 4GB). Adding startup option -T845 is unnecessary on a 32-bit...

Did you try the code I provided?

As a side note, having your SQL Server run as a Domain Admin is quite dangerous considering you're about to open this up for users to send emails with attachments....

dba0419 (8/17/2012)

---

There is only 1 login being used (for testing this issue) and that login has full control of the network share and is in the DatabaseMailUserRole Database Role.

Example:

EXEC msdb.dbo.sp_send_dbmail...

It has nothing to do with the caller, and everything to do with the SQL Server service account. When you try using Database Mail the attachments need to be accessible...

Epic

You cannot change the login mapped to the dbo user either...at least I could not on 2005, 2008 R2...