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

Support for EVENTDATA() ?

Hello redgate folks. It would appear that SQL Prompt does not support the EVENTDATA() function, or perhaps it doesn't like the XML data type. I can't tell which. All I know is when the EVENTDATA function appears in my code (in my case, database DDL triggers), SQL Prompt stops working.

Would someone be so kind as to have a look?

Thanks all.
Dave Pendleton
0

Comments

3 comments

Sort by
  • Eddie D
    Hi Dave

    Thank you for your forum post.
    What version of SQL Prompt are you using?

    Many Thanks
    Eddie
    Eddie D
    0
  • Dave Pendleton
    That would help, wouldn't it? My apologies.

    SSMS: 18.2 (15.0.18142.0)
    Visual Studio: 2017 15.9.16
    SQL Prompt: 9.5.16.11294

    Regards,
    Dave Pendleton
    0
  • Eddie D
    Sorry for the delay in replying.

    I have just tested SQL Prompt V10.0.10.13591 using the EVENTDATA() function and appears to be working and providing suggestions.

    Many Thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.