SQL Prompt does not show CLR assemblies

dsp

When I try to execute a CLR assembly procedure, SQL Prompt does not recognize it.

Anu D

Many thanks for your post.

Unfortunately SQL Prompt v4 does not yet support CLR types (including xml) and so it fails to prompt suggestions.

I have logged this as a feature request in our internal tracking system whose id is SP-2866.

Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.

dsp

Ok, thank you for your answer, I'll hope it will appear in the next release.

fatherjack2

I would also vote for XML formatting to be reviewed in future versions.

Taking the Books OnLine example from http://msdn.microsoft.com/en-us/library/ms186918.aspx the WITH block from example B gets treated as a single line rather than as a column list when formatted by SQL Prompt + SQL Refactor