This script checks to see if startup procedures are running on this instance of SQL Server and will return a list of stored procedue names.
There can be valid reasons for wanting to to have stored procedures run on startup. But there are also devious people out there Make sure you know what each of these are doing and check periodically.
As with any condition this can be disabled at varying different levels of the hierachy in the navigator window.