These settings are stored in the registry . EM uses an undocumented xp called xp_instance_regread to enumerate the relavent keys
xp_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....
HTH
Jasper Smith
How to specify server default db propertities
Posted - 10/04/2002 : 16:28:06
