missing source code on SqlServer Routines.

As a temporary workaround, invoke `Database Tools -> Forget cached schemas` action and sync again.

Thanks, it worked.

workaround helped me too -- is there a bug I can follow for this?

There is an issue https://youtrack.jetbrains.com/issue/DBE-6738 you can follow. 

Where do I find the workaround on DataGrip for Mac?

@Wilhelm Fauma Have you tried :

>As a temporary workaround, invoke `Database Tools -> Forget cached schemas` action and sync again.

?

@Vasily Chernov: Well, I do not have that menu item.  That's why I was asking where I can find that on the Mac client.

You need to invoke right click context menu on data source:

@Vasily Chernov: Yes. that worked.  Thanks a lot!

This does not work for DataGrip 2018.2.4 Build #DB-182.4505.23

Correction - Had to add the following schemas to the "Manage Shown Schemas" filter so sync would display the proc/func code:
sys
information schema

@ MitchyGoodness 
Could you switch to DataGrip 2019.3?