What startup stored procedures are we running?

For some environments certain actions must be taken when SQL Server starts up. For some customers temporary tables or other types of transient objects must be present in the Tempdb. Developers or DBAs will then create “start up stored procedures” to ensure that when SQL Server starts up these procedures will execute. What happens if the…