What are the challenges you face when working across database platforms? Take the survey

SQL Prompt does not show CLR assemblies

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


  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Ok, thank you for your answer, I'll hope it will appear in the next release.
  • Options
    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

    Senior DBA
    Careers South West Ltd
Sign In or Register to comment.