My UDT works fine on the server and ToString() will work on the type in a
Select. However, even if I install .dll into GAC, SSMS will not display my
UDT as a string (i.e. does not call ToString()) so I get byte display
instead of string. Anyone know what to look for (i.e. error log, etc.)?

--
William Stacey [MVP]

I think it doesn call the tostring Method, but your implementation of
the UDT is defined in the attributes of the class as UserDefined. With
overriding the ToString() method and implementing you own this should
work for you.

HTH, Jens Suessmeyer.

That is the question. I have the ToString() override already. It is not
called. Others in blogs say this should work using SSMS, but mine does not.
One post said it would not work in RTM, so I am not sure if it even should
work or not. And SSMS or Help gives not help I found yet.

--
William Stacey [MVP]

"Jens" <Jens (AT) sqlserver2005 (DOT) de> wrote

As far as I know, that's correct behavior. SSMS will never call ToString()
for you automatically.


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--


"William Stacey [MVP]" <william.stacey (AT) gmail (DOT) com> wrote

I know it did at one point as I see blog posts about it. Maybe not in RTM.

--
William Stacey [MVP]

"Adam Machanic" <amachanic (AT) hotmail (DOT) _removetoemail_.com> wrote

Right -- it was removed, IIRC, in the September CTP.


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--


"William Stacey [MVP]" <william.stacey (AT) gmail (DOT) com> wrote

Anyone know why this is? It would have seemed to be bone simple to at least
add a check box in options to enable/disable this feature.

--
William Stacey [MVP]

"Adam Machanic" <amachanic (AT) hotmail (DOT) _removetoemail_.com> wrote

Agreed... Put in a "suggestion" and I'll vote for it...

http://lab.msdn.microsoft.com/productfeedback


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--


"William Stacey [MVP]" <william.stacey (AT) gmail (DOT) com> wrote

FDBK43960
Cheers.

--
William Stacey [MVP]

"Adam Machanic" <amachanic (AT) hotmail (DOT) _removetoemail_.com> wrote

For others reading this thread who want to cast a vote:

http://lab.msdn.microsoft.com/produc...a-d22a4ed31ecc


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--


"William Stacey [MVP]" <william.stacey (AT) gmail (DOT) com> wrote