Not yet.. still reviewing the posts.

Erland Sommarskog (8/8/2013)

---

If you run out of workers, this is likely to be due to one of the following (or a combination thereof):

1) There are simply too many active users.

2)...

When...

IT will not allow us to use the SA account, so there is no way.. that I know of .. to get into the server when it is effected. Once...

Unable to log into the server and ...

SQL Server Alert System: 'Out of Workers' occurred on <Server Name>

DATE/TIME:7/17/2013 8:53:43 AM

DESCRIPTION:New queries assigned to process on Node 0 have not...

Louis and Chris thanks for your help! 🙂

The query gave me a multi-part error on Base.Post_DM

I changed it to the following:

;WITH base AS (

SELECT Max_DM = MAX(post_dm) FROM ztb_forecastable_metrics_hist

)

SELECT

post_dm -- etc

FROM ztb_forecastable_metrics_hist

WHERE post_dm...

Luis Cazares (8/6/2013)

---

Why are you using a CTE when a normal query could work?

If you give us more information on your query, we might suggest something different, but to solve...

Ok.. good point on the testing for removed 'review' check (it is a bit column). I was trying to isolate the trigger stamping .. since it is so critical to...

Oooo so close...I tried to add an 'ELSE' statement to remove the stamp.. if the App has set 'Review' to 0 or NULL, but got the following error:

Msg 4104, Level...

I didn't try to log in from the server.. but the SQL server log did not have anything at all in it.. for the time in question. The same is...

This effects all the SQL server jobs connecting to this server, and all users connected. So for users we have both Management Studio, and .Net Apps.

Great.. how would this work with an insert? Would it execute? If so how would we wrap this in an IF statement to only run when updating the row.. not...

Ok, thanks. Since it fixes the multi-row failure.. then how would I put in a IF statement to only execute if the record being written contains a data change in...

Date7/25/2013 8:41:00 PM

LogJob History (Refresh BOR Table)

Step ID1

ServerNDCASPSQLP03

Job NameRefresh BOR Table

Step NameRun New SSIS Package

Duration00:00:06

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: <Domain>\<user>. Microsoft (R) SQL Server...