Les Cardwell (6/30/2012)

---

Hmmm...no joy. No matter where I put 'sp_getapplock' in the DDL, it chokes. There are also no similar examples in BOL, only...

USE AdventureWorks2008R2;

GO

EXEC sp_getapplock @DbPrincipal = 'dbo', @Resource...

Can you provide us a copy/paste of the raw with the missing data that's causing the error? If we can see the error specifically and have the raw to...

rjbirkett (6/29/2012)

---

While I was thinking about all this, I wondered if, since there are only 2000 calls a day to the call center, could I use a trigger to run...

Wrap this DML in an applock.

Basically:

CREATE PROC blah AS

sp_getapplock

Begin Tran

...

End Tran

sp_releaseapplock (or whatever it's called, that's close)

END

What that'll do is force a waitstate at the sp_getapplock until it can...

I assume multiple calls against the same proc are what's causing the deadlocking, or is it deadlocking itself?

If it's multiple calls, you might try using an sp_applock wrapper in the...

Lynn Pettis (6/29/2012)

---

Looks like you miss things you shouldn't or find things you shouldn't. Just means you can't totally automate the changes you are trying to make.

I should know,...

Lynn Pettis (6/29/2012)

---

Evil Kraig F (6/29/2012)

---

I may have just realized the problem. Thanks for the reminder Michael, I went off escaping and didn't really think through the allowable characters...

End to end code. I just got SLAMMED at work before the weekend starts up so I need to clear a few things, luckily I comment as I go....

Running through an iteration on the methodology and I've run into a bit of a confusion.

I'd thought SntDt and RcvDt would simply be directly associated to if it was a...

GilaMonster (6/29/2012)

---

Evil Kraig F (6/29/2012)

---

GilaMonster (6/29/2012)

---

Order they are requested in. Otherwise it would be possible to have a 'lock starvation' condition where newly requested locks jump in front of older...

I may have just realized the problem. Thanks for the reminder Michael, I went off escaping and didn't really think through the allowable characters for the pattern replacements.

Please remember...

DataAnalyst110 (6/29/2012)

---

Hi Craig - What does the > 0 do in your query? I looked on MSDN to find out what CHARINDEX does. But I haven't seen anything like that...

The expression looks fine. Either it's not mapped to a second stream or something else went funky.

Drop a dataviewer onto the stream it's NOT supposed to be in and...

Use CHARINDEX() > 0. Don't use PATINDEX though, same problems as LIKE.

Basically:

SELECT * from syscomments where CHARINDEX( [text], '*') > 0.

Easiest workaround I'm aware of.

Lynn Pettis (6/29/2012)

---

Craig, feel free to jump in like you did with that wonderful explaination. Code wise, you may be right, we all code slightly differently,...