Skip to main content
7-Bedrock
May 1, 2022
Question

How do I get field comments in sqlserver tables

  • May 1, 2022
  • 1 reply
  • 796 views

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

chenzhuang111_0-1651377142580.png

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

1 reply

Support
May 5, 2022

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