I've written a service to replace the SQL Server Agent service to be independent of Agent when moving to Express versions of SQL Server which do not include Agent. Obviously on older 2000 MSDE versions I don't want Agent and my service running at the
same time so I need to turn off Agent but there are SQL Server Properties such as under the General tab, "Autostart policies when the operating system starts" section and I need to uncheck the "Autostart SQL Server Agent". In SQL Server Enterprize Manager
I can right click the server then select properties and general tab.
How do I change that property either via T-SQL or via VB.NET to uncheck it?
View Complete Post