Actually, looks like I was overlooking something ...

After putting the execute as 'dbagent' back into the trigger and granting execute permission on the procedure, now I simply have the problem...

ARGH, so If I take this route, I'm still going to have drop this user in all databases (with the execute as in the trigger) ... again, not a big...

Good point, that will definitely work.

Thanks

Good thought, put the execute as in the trigger ... yet being that I can't execute as sa ... what is my alternative if any here for an execute as...

Well, I ended up going to dynamic SQL and it's working like a champ. It's also caching the plan and re-using properly.

Thanks guys!

Yep ... I guess this is something some BA type people can run from...

Yeah I wish I would have been at PASS instead of the DevConnections conference ...

Well, that sucks, but it is what it is. While I'm not a fan of dynamic...

It's actually hitting an index seek every time ... and everywhere else I use this type of logic, normally performs like a champ. The piece I left out about this...

So this is crazy ... I just checked the estimated execution plan, and it looks like it's attempting to bring back ALL the records in the WHERE clause. Granted this...

Thanks. I've actually done quite a lot of work to it since this post and after attending this DevConnections conference in Vegas, I have even more stuff I plan on...

Yeah but I'd at least like to be able to somewhat be able to translate those that are close ... those with misspellings, or bad characters. I was thinking...

Yes, I have pointed it at another location which worked just fine after doing a manual backup with format.

Yeah that was my test yesterday and this morning ... I was able to back it up to another location without problem. I've never seen such odd behavior ... especially...

That I have ... I removed the file yesterday and created a new backup manually, worked like a champ. Then the nightly blew up.

I repeated the same process today, but...

Backing up to disk. Not using devices. I overwrite the same file everyday (soon to change actually).