see answers below.
- Exporting to Excel Instance /Excel linked query: fails
On our side Export Linked Query functional works ok. I saw, that TSS display
error message “translation: Object type is not compatible with the type of
target”. I think that you export specific data that could not be
converted. Could you send us the object that you are trying to export,
we’ll look at it.
I cannot export any data.
sample query: select top 10 * from sys.objects
- Support for XML : fails - result is treated as ‘normal recordset’
Could you please describe this problem in detailed way?
I’ve already wrote about it
SQL Management Studio result:
- Export of XML results: fails
On our side Export functional works ok, please send us your xml.
topic was also already described -
try to export to xml [using tools / Export / Export Wizard ]
select top 10 *
from sys.objects for xml auto
- ‘asymmetric approach’ to verify sql vs run script [in both cases nothing is
First checks only statement that contains cursor, second - runs whole script
Can you please be more specific here, I’m afraid I can’t fully
understand this item.
when query contains few statements, and I press F5 [run] all statements are
But if I ‘verify sql’, to check all statement I have to select them. If not -
only ‘current will be checked’
- I cannot switch output to text mode [I know it is not an error]
Right-click and uncheck Text Output option
this way you can change format of messages. I’ve been talking about results.