Information about "Windows Services" follows:
01. Open "Computer Management" console.
02. In the treeview find "Services"
03. Tab "Standard", sort by "Name"
04. Highlight anything in the window, keyboard press "S"
05. See (all) the "SQL Server (
your instancename here)"
06. Right click select "Properties"
07. On "General" tab see "Startup type:"
08. Using that dropdown box, select "Automatic"
09. [optional] Hit "Start"
10. Hit "Ok" to close dialog.
11. [optional contingent upon 09] Restart computer
One solution to a non-running SQL Server instance at computer start. There might be a few more things that prevent it from starting.
[edit]
The stoproc enabling TSQL will look something like this
DECLARE @ProcName [nvarchar](146)
SET @ProcName = '[master].[dbo].[your sp_name here]'
DECLARE @OptionName [nvarchar](599)
SET @OptionName 'startup'
DECLARE @OptionValue [varchar](61)
SET @OptionValue = 'TRUE'
EXEC sp_procoption @ProcName, @OptionName, @OptionValue
The stoproc you create could be anything that doesn't raise an error in the CREATE stage. As you'd expect, automation is about what's inside the thing that's already running.
[end edit]