LOL Understood -...

Its obvious that the event is being sent to the second thread before the transaction (first insert) has committed, regardless of what is going on in your second procedure.

I will...

RPC calls are not the same as actual TSQL statements or procedures run directly against SQL server. They run inside of of the RPC server process, so just because thread1...

Shouldn't take that long, the process must be being blocked.

Jeff Moden (12/18/2013)

---

If there's only one level of children, such as you might find in an Invoice/InvoiceDetail problem, then I absolutely agree. If it has more than 1 level...

What you have presented looks like an ugly design. The PK appears to be a string that has a 'EXPXX' suffix appended to it. Then you must apparently strip the...

Grant is right on. Your use of sp_executeSQL is superfluous in terms of preventing injection the way you have implemented it. Read BOL on sp_executeSQL and learn how it works....

robin.pryor (12/12/2013)

---

I have a lot of confusion around the fact that I have to use DEVSQL03.CDB.ORG to connect to the server, but SELECT @@SERVERNAME returns DEVSQL03. That has to cause...

It appears the server was added using a fully qualified domain name like: server.domain.com. To be honest I have never considered the impact that might have on referencing database...

Is Server1 the DNS alias name?

Have you set up that as a linked server? What does the sys.servers entry look like?

You'll have to restore the most recent back with standby

yes. modify the stored procedure to do the bulk insert into your stage table first, then encrypt the column in place or encrypt by inserting into your final table...

If you want and have the desire to, you can script out all of the Agent jobs using method from SMO from a .net utility. I actually do this on...

The first thing you need to do is sum up the items - group by each month:

select mm=datepart(month,Date), itemRef, QTyTot=sum(Qty)

from Purchaseorders P

JOIN Items I on I.PoNum = P.PoNum

group by datepart(month,Date),...