A 'PRINT SUSER_SID()' query yields a binary value but how do I modify
this query so that the output in the Query Analyzer is:
---
SUSER_SID(): 0x010500005150000EE940207DCF4DC3B43170A3
2F401000
---
i=2Ee. I want to concatenate the string 'SUSER_SID(): ' with the binary
value. I tried
---
PRINT 'SUSER_SID(): ' + CAST(SUSER_SID() AS varchar)
---
but QA generates the output as
---
SUSER_SID():
---
Thanks,
ArpanArpan
Is that output from sysprocesses table ?
"Arpan" <arpan_de@.hotmail.com> wrote in message
news:1121857262.470508.114610@.f14g2000cwb.googlegroups.com...
A 'PRINT SUSER_SID()' query yields a binary value but how do I modify
this query so that the output in the Query Analyzer is:
---
SUSER_SID(): 0x010500005150000EE940207DCF4DC3B43170A3
2F401000
---
i.e. I want to concatenate the string 'SUSER_SID(): ' with the binary
value. I tried
---
PRINT 'SUSER_SID(): ' + CAST(SUSER_SID() AS varchar)
---
but QA generates the output as
---
SUSER_SID():
---
Thanks,
Arpan
No comments:
Post a Comment