Chris,

Try changing your Grid results and Text Editor fonts to Arial.

I just realised it was possible that you were trying to display arabic characters in a font that did not...

CONTEXT_INFO() can only hold 128 bytes, so converting NVARCHAR(128) will lose data, but only if the login is longer than 64 characters.

I take it the column in your audit table...

chris.king (6/8/2011)

---

Originally, I was using VARCHAR as follows:

DECLARE @SYSUSER VARBINARY(128)

SET @SYSUSER = CAST(CAST(@LoginName AS VARCHAR(128)) AS VARBINARY(128))

SET CONTEXT_INFO @SYSUSER

This worked.

Then came the new requirement to be able to support non-unicode...

chris.king (6/8/2011)

---

So I'm now setting context_info as follows, please note that the field from which @LoginName is derived is now also NVARCHAR(128):

DECLARE @SYSUSER VARBINARY(128)

SET @SYSUSER = CAST(CAST(@LoginName AS VARCHAR(128)) AS...

I dispute that it is hard to google that question:

http://tinyurl.com/3t5p6es :w00t: 😀 😛

sradoff (6/7/2011)

---

The VB6 COM+ is installed as a COM+ application on the Web server. Both the Web and SQL Server O/S run in the same workgroup. There is a group...

Nah Steve, it is just part of the "Classic" skin...

Is the VB6 COM+ installed as a COM+ application on the SQL server or is it just a COM dll that is called by something else?

Basically it sounds like the...

ALZDBA (6/7/2011)

---

I get to see it in...

Steve Jones - SSC Editor (6/7/2011)

---

Craig Farrell (6/6/2011)

---

calvo (6/6/2011)

---

wow. I was about to question this when I looked it...

Not done one yet this week, but similar to Stuart, I have already done a double shift yesterday - finishing at 2.30am and doing another double shift today... bound to...

(Breaking my own promise to keep out - sorry 😛 )

This thread is RBAR... I have a set based solution:

http://www.ocf.berkeley.edu/~wwu/cgi-bin/yabb/YaBB.cgi?board=riddles_medium;action=display;num=1027804564

No tally tables!

me.hacked (6/3/2011)

---

Hello, i was searching for some help, and maybe someone could help me with my problem!

I have to get a MAX from an Account Balance..

I'm using a query...

@GSquared:

It seems that (for me at least) it works as long as you remember that your final

SELECT *

FROM dbo.LockTest

is the part that is being blocked...

Thanks for the feedback.

It worked fine on mine, but I was not specifying certain IDs.

I will try your version and see if that is the reason.