Keep in mind I don't know the answer, I am postulating ideas..

First glance is you need to enumerate the groups and see if any of their members are other groups....

I don't disagree, I built this script about 3 years ago..

SELECT Cmd = 'CREATE LOGIN ['

+ name

...

After MUCH hair being pulled out (which is a problem, see my avatar picture) I finally found the issue..

Thank you Pro T-SQL 2012 Programmer's Guide by Jay Natarajan (et all)

Page...

I agree with Jeff's position.

Getting the databases over can be easy, just shut SQL down and copy over the files to the new server and then attach them. SQL...

So locally can you log in with SA or not? But externally you can't. I didn't quite catch it..

CEWII

This feels like homework...

I'm having a hard time figuring out how this would be used and what use it provides?

CEWII

My first thoughts are:

1. What is your max memory set at? I'm guessing it is the default, change it to at most 14336MB (14GB) You need to leave space...

I don't have adventureworks installed so I'll have to wing it..

If you get the email list into a table it becomes pretty easy..

DECLARE @Wk TABLE ( RecId INT IDENTITY(1,1) NOT...

My first thought was, no way would I do this. If the Agent is running on both then it you have no way of know which one will run...

My first thought would be firewall on the receiving end. Is that port open?

CEWII

Bump replaced with answer..

After MUCH hair being pulled out (which is a problem, see my avatar picture) I finally found the issue..

Thank you Pro T-SQL 2012 Programmer's Guide by Jay...

Completely agree Lowell..

CEWII

No, there really isn't, however, there is a SQL CLR object that might help. Off the top of my head it doesn't really support it either but I think...

They are handled asynchronously as far as I know AND have seen. However, I have seen in some cases a SQLCLR making web calls "lock up" and in none...

Jeff Moden (11/22/2013)

---

Sorry, Elliott. I absolutely agree in most cases and didn't mean to make it sound contrary to what you said. Rather, my intent was to support your...