How do I get field comments in sqlserver tables

[chenzhuang111]

hi ,as the title ,How do I get field comments in sqlserver tables

and I tried the method in the picture but it didn't work

[slangley]

Hi @chenzhuang111

Have you verified you can connect to the db from ThingWorx?  Does the db user have access to the table you're trying to access?   Are you able to run any query?  Try this one: 

select @@version

You should also check to validate the db user account isn't locked.

Regards.

--Sharon