When highlighting a Linked Server Table (...) in MS SQL Server, when you press Ctrl-D to get a Describe of the Table, it returns the error ".. does not exist. Is there a way you could generate the Describe Information for a Linked Table?
Also, if you try to do the "Execute Edit" against a Linked Server Table, it gives you the error message "Failed to set the current database".
This is a known issue. The current data studio design for describe and execute edit does not support extraction of object information through a linked server. This has been requested before and has been discussed but the eng. effort is significant and is in que for future release. Will assign issue to Sachin to assign to appropriate release.
This is a known issue. The current data studio design for describe and execute edit does not support extraction of object information through a linked server. This has been requested before and has been discussed but the eng. effort is significant and is in que for future release. Will assign issue to Sachin to assign to appropriate release.
Sounds good...
For SQL Server, you can use sp_columns_ex '<Linked Server>','<TableName>' to return column information
Sounds good...
For SQL Server, you can use sp_columns_ex '<Linked Server>','<TableName>' to return column information
Issue #9793 |
| Closed |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Also, if you try to do the "Execute Edit" against a Linked Server Table, it gives you the error message "Failed to set the current database".