November 30, 2006 at 6:42 am
Is the SQL Server Agent Auto Start option stored in the registry or within the database?
Any ideas.
TIA
November 30, 2006 at 7:59 am
I got this information in msdb..sp_set_sqlagent_properties
November 30, 2006 at 8:06 am
Registry!
EM uses xp_instance_regwrite and xp_instance_regread to get and modify these settings.
December 5, 2006 at 1:28 am
Its in registry. You can verify this information from regedit:
HKEY_LOCAL_COMPUTER\software\Microsoft\Microsoft SQL Server\<your instance>
Pankaj Khanna
Database Administrator - SQL Server 2000
Keep hope to keep you intact...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply