These settings are stored in the registry . EM uses an undocumented xp called xp_instance_regread to enumerate the relavent keysxp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultData'xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultLog'
There is also an xp_instance_regwrite xp that will write to the registry e.g.xp_instance_regwrite N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultData',REG_SZ,N'e:\sqldata\data'xp_instance_regwrite N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultLog',REG_SZ,N'e:\sqldata\log'
These are undocumented (by MS - if you search google you will find articles on how they work) and unsupported so use at own risk etc....HTHJasper Smith