User Defined Types in SQL Server

How does LinqPad resolve columns that have are defined with a UDT?

Comments

  • It should translate them into the underlying type. Is is not working for you?
  • It works in the development version of the database, but not the production version. I am sure it is some kind of privileges thing, but I am not sure where to look for. Also I have limited access to production.
  • I believe the reason is that a certain privilege is required to see the user-defined type. Here is a link to an article.


    Without GRANT VIEW DEFINITION privilege, this is not possible.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!