I was going through one of our databases in order to answer a question from the boss, and I peeked at a stored procedure. As usual, I right-clicked it in SSMS, clicked Script stored procedure as... then create, and to my surprise, all I found was the CREATE PROCEDURE statement:
To double-check, I had someone else look and they got the same thing. They were signed in as database owner, I was signed in as sysadmin. I next ran
select m.definition from sys.procedures p left join sys.sql_modules m on p.object_id=m.object_id where p.name in ('spPUpdateContactUserLockout', 'spPLINK_SYNC_CONTACT');
I've not seen this before. Ever. I didn't think one could create a stored procedure without defining a body, and there are several such procedures in multiple databases on this instance. At this point I'm concerned, but I'm not sure if I don't have to be or if I should be more concerned than I currently am.
This instance is SQL Server 2017 Standard x64 RTM-CU11, and I'm using SSMS 17.9. Any insight is appreciated!