I am not quite sure what you want to know, but to control whether an instance is starting automatically or not, go to:
Start Menu | All Programs | Microsoft SQL Server 2008 R2 (or whatever your version is) | Configuration Tools | SQL Server Configuration Manager.
The services will be listed under SQL Server Services.
Ole Kristian Velstadbråten Bangås -
Virinco -
Facebook -
TwitterConcatenating Row Values in Transact-SQL[/url]