Successfully compile sp_whoisactive in Azure Synapse (azure sql data warehouse)

amachanic / sp_whoisactive

sp_whoisactive

GNU General Public License v3.0

1.14k stars 281 forks source link

Successfully compile sp_whoisactive in Azure Synapse (azure sql data warehouse) #25

Closed gorkam23 closed 2 years ago

gorkam23 commented 4 years ago

I've gone through and updated the SP with the Synapse DMVs, but I keep on getting this error:

Msg 103010, Level 16, State 1, Line 12 Parse error at line: 528, column: 36: Incorrect syntax near 'r'.

I've attached my work in progress because I couldn't open a pull request.

Thank you

sp_whoisactive_ASynp_inprogress.zip

erikdarlingdata commented 2 years ago

Hi there! Thanks for the file, but I don't think anyone actively working on this has Azure Synapse available to test things on. If you get this working, drop us a line. But for now I'm going to close this out.