Thank you for your response. I did read your write up, just was unable to deduct my questions from it.
I did not fully understand response about using HAG listener...

Well this work but the problem is that UI does not allow you to restore more then one TRN file at a time and I make full backup every 4...

This does not help, it just somehow can not see full backup when trying to restore log backups.

Grant Fritchey (5/20/2015)

---

Not that I'm aware of. If I try to use code in that fashion it generates an error. You could substitute a local variable or hard code a...

If I grant "create table" to [com], would not that mean this user can create table in dbo schema as well as in [com] schema and everywhere else?

Thanks. I though being owner of the schema allows user to do everything it wants.

Is there a way to allow all available permissions to [com] user?

I want [com] user to...

Why do I need to create another user if I already have a user which has full permissions and can not create TABLES etc?

it does not work since [COM] already owner of the schema and hence have all permissions needed

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or...

KenpoDBA (1/5/2015)

---

Quite often in companies, they deny servers the ability of servers to use exchange as a relay server. You have to ask your email admin to add your...

Yes everything is installeed. Again relaying through localhost works, just relaying through remote system does not.

No, Agent error log is clean of any errors. The only one there about Messenger service which is not started which has nothing to do with SMTP.