Many and/or large sorts can end up in tempdb once memory is exhausted.

So if you have an unusually great number of connections running that query at the same time, it...

When I run the two queries (outer join vs NOT EXISTS),

the outer join query runs in 4-9ms (69 logical IO n the temp tables and 0 scans and 0...

Is it possible your login has DENY "alter any user" on the database?

What error do you get?

Also, can you answer the other questions I asked

From BOL: Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE database-level...

Do you only have db_securityadmin role on the databases, or does your log have have the securityadmin fixed server role?

If you only have the db_securityadmin role on the databases,...

Jeff Moden (11/9/2013)

---

Very cool. I'll start with a bit of a play on words. "Just because...

Do you have more info?

What is the job doing?

A talk about how to determine the right tool for the job.

Or a talk about the appropriate use cases for certain new features and examples of (common?) incorrect application of...

Do the domains have trust set up? The test Domain must trust logins from the prod domain.

The error indicates that may not be the case.

When you added the windows...

You had to drop the publisher, because that is what drops the log reader.

It is important to understand which replication piece each replication agent is related to.

Mind you, this is only a band-aid.

You really should identify the query that is causing the issue and tune it.

You could set maxdop to 12 or 8 and see if that helps.

You can set MAXDOP to half the number of cores on your server if the instance is the only instance on the server.

Fewer if more than one instance is on...

cs_troyk (11/1/2013)

---

arnipetursson (11/1/2013)

---

Am I the only one bothered by the lack of unique constraint/index on the natural keys in in the new tables.

The new design allows the insertion of duplicate...