User Defined Types in SQL Server

abhi
abhi
in General
How does LinqPad resolve columns that have are defined with a UDT?
· Share on Facebook

Comments

  • JoeAlbahari
    JoeAlbahari
    It should translate them into the underlying type. Is is not working for you?
    · Share on Facebook
  • abhi
    abhi
    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.
    · Share on Facebook
  • abhi
    abhi
    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.
    · Share on Facebook

Categories