Hi Lowell,

Thanks for your reply. We need to call a function from a view; the function contains complex calculation, whuch needed dynamic sql.

There are number of limitations:

1. We cant call...

Hi,

I am sorry that I hv not informed you...this issue has been resolved. I have reinstalled SQL server with mixed authentication and now it is working fine. Previously it seemed...

Hi Nakul,

Thanks for your response.

Problem is I am not able to open any editor even to run this error message. I ahve not the administrator of the machine,but I have...

Hi,

Any solution for my problem?

Regards,

Arup

Thanks Anthony

anthony.green (3/19/2012)

---

your problem is your storing binary in a textual data type not as a binary data type which is why you are getting the different errors

select CONVERT(binary(16),'0x2139aec19f212447bb23ba307d611a1e') will give...

Thanks Anthony, I will try this and let you know

Hi,

Sorry as I cant post code or table def. for security reason.

Could you just answer one thing:

I have this type of column( ex. 0x2139aec19f212447bb23ba307d611a1e) already in binary format but the...

Hi Anthony,

This is not the problem with ntext conversion. I ahve extracted uid as nvarchar from the ntext. Now need to convert that uid to binary which is throwing error.

declare...

Hi Anthony,

Thanks for quick reply. Actually I am parsing this string from a ntext column and storing this inside a table variable. If I am putting my table variable...

Thanks Ninja

Hi Ninja,

:):-) I have done the same way you have give. Actually just to enquiry is there any short cut or not.

Thnaks ton,

Arup

Hi Sartori,

Thanks for the response. I am aware of that method but my question is, shall I put TRY-CATCH block inside the CREATE VIEW statement?

Regards,

Arup

One more thing, this is entirely related to future performance. If you guys fill that there will not be any performance issue, then please let me know.

I think, ...

Hi

Is there any update on it? Or this is an entirely new scenario 😀