a sproc with a brass padlock on it

If you are browsing the Stored Procedures under Programmability for a database in Microsoft SQL Server Management Studio and you see a sproc with a brass padlock on it, that means that the sproc isn't a sproc at all, but is instead a CLR object which may be called as one might call a sproc.