That's not an option either.

Yes.  Unknown locations Y.

Access lists are not currently an option.

I can understand the sentiment.

I have several dozen SQL servers hosting a few thousand databases.  Each of the N databases has X users who connect from Y locations.  Connections come in...

I am prepared to declare memory / virtual memory as the cause.

I increased the memory on the box but still had the same problem  A quick system check (which I...

Never heard of such a thing.  I think you are making that word up.

Thanks for the replies.  I think that lack of memory is likely the culprit.  I re-ran the query with results as text and it dies at about 2.8 million rows...

Hello,

Thanks for the reply. 

Actually, I heard back from the Microsoft Windows Web Hoster program over the weekend and they state that only the Active node needs to be licensed.  My apologies...

Hey Frank,

Thanks for the link. 

I think what I am trying to do is more like cheating.  I don't want sql to use more than the 2GB that it can...

For now having these users as dbo/db_owner is a business requirement.  Hopefully we will be able to change this in the future, but not yet.

Why is it that db_owner can...

bump

I can't believe that noone else has encountered anything like this...

Makes me think I'm imagining things.

Thanks for the reply.

Unfortunately there is nothing out of the ordinary running under TM unless a legit exe has been replaced with a hacked one.  Likewise there are no new...

What about the file sizes?

Here is a sampling of sqlservr.exe on several servers, including one brand new one.

sqlservr.exe size (sizeOnDisk)

Public Server - 7,544,916 (7,548,928)

Public Server - 7,544,916 (7,548,928)

Public Server - 7,544,916...

It also looks like it is trying to spoof the source IP and MAC address...  For example, I have two nics on this box - one with internal, one with...

But, what about clients connecting directly via EM?  Is it possible to collect their local sql service pack level?

-Dan B