Support for EVENTDATA() ?

Dave Pendleton

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.

Eddie D

Hi Dave

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

Many Thanks
Eddie

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,

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