How can we help you today? How can we help you today?

SQL Prompt - Bug?

We have some older procs that use PWDCOMPARE. We've found that SQL Prompt does not work (e.g., no intellisense, no auto-formatting, etc.) if we type statements after the PWDCOMPARE. In the same proc SQL Prompt works fine when typing before PWDCOMPARE.
CMeese
0

Comments

5 comments

Sort by
  • way0utwest
    What version of SQL Prompt? Seems to work in v8
    ybubaozgn13d.jpg
    way0utwest
    0
  • CMeese
    Version 8.2.2.2657.

    Maybe it's the use of PWDCOMPARE in a statement such as: chh46nqw71dg.jpg

    When I change my SQL to be like your example SQL Prompt works fine:
    4yjkk96359rg.jpg

    CMeese
    0
  • way0utwest
    That's strange. Yep, seems like a bug. Reporting to the dev team
    d2hpywi1wkxs.jpg
    way0utwest
    0
  • CMeese
    great, thanks!
    CMeese
    0
  • krzysztofkroczak
    Hi @CMeese and @way0utwest,

    Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6655) to track it.

    Best regards,
    Krzysztof
    krzysztofkroczak
    0

Add comment

Please sign in to leave a comment.