[dba-SQLServer] XML setting files

This is an example of the type of files I am referring to:

<?xml version="1.0" encoding="utf-8" ?>
<Settings>
<MaxNumInQueue>0</MaxNumInQueue>
<MinWarningInterval>240</MinWarningInterval>

<MailPort>25</MailPort>
<MailServer>fcmail.xxxxxx.com</MailServer>
<MailTimeout>30</MailTimeout>
<MailSender>OpsAlert at xxxxxxxxxc.com</MailSender>
<MailSubject>Activation errors for Carrier</MailSubject>
<MailMessage>There are %d orders with Activation errors .
</MailMessage>
<ConnectionString>Provider=SQLOLEDB.1;Initial Catalog=xxxxxxxxx;Data
Source=xxxxxxxx;User Id=xxxxxxxx;pwd=xxxxxxx;application
name=xxxxxxxxxxx</ConnectionString>
<SQL>
Execute dbo.XXsp_MonitorErrors
</SQL>
<Recipients>
<To>xxxxxxxx at xxxxxx.com;xxxxxx at xxxxxx.com;</To>
</Recipients>
</Settings>

It would just seem good practice to me to name the files based on
something descriptive so that when have have 100's of settings files,
we don't make mistakes as to what file goes to what process.
By boss still says: > "The settings file is use as input into the XML
process, it works kind
> like the .ini file.  However the XML software looks for a file name
> settings.xml. If you are not clear, please let me know."  

I don't want to make a pest of myself but I also don't want at some
time in the future have to correct any problems that come up.

Any help appreciated.  I just need to convince him this is possible
and a good idea.

Thanks,
Nancy
On Fri, 4 Feb 2005 12:57:47 -0800, Charlotte Foust
<cfoust at infostatsystems.com> wrote:
> An XML file is a text file and you can read it with any text editor.  It
> has nothing whatsoever to do with any XML "software" unless you've
> written software to look for that file name.  If the application
> software is in .Net, it may be using typed datasets based on a file
> named Settings.xml and/or it may contain a class to manipulate that xml
> file.
> 
> We import and export xml files with different names and we store
> settings in xml files with specific names.  We also use xml files to
> store lookup values that are not part of the back end data.  None of
> them is named Settings.xml but we do have to program for specific xml
> file names.
> 
> Charlotte Foust
> 
> 
> -----Original Message-----
> From: worddiva [mailto:nancy.lytle at gmail.com]
> Sent: Friday, February 04, 2005 12:49 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] XML setting files
> 
> I know this is a little off topic but we do use SQL Server with XML and
> I know next to nothing about XML, but I have been tasked with going into
> some settings files and adding the application name to the connection
> string, and replacing the in line SQL with a stored procedure. All of
> the files are named 'settings.xml'  no matter what they are used for or
> in, it is always settings.  I suggested we might want to change the file
> name to something more descriptive than settings, but my boss says that
> the file must be named 'settings.xml'.  Is that true?  Or is it that if
> we rename the file, we must also rename in the application .exe? My
> supervisor stated
> "The settings file is use as input into the XML process, it works kind
> like the .ini file.  However the XML software looks for a file name
> settings.xml" Already I have run across a situation in SourceSafe where
> a settings file was listed under the wrong process, which is what I
> think we should be trying to prevent.
> 
> Thanks in advance,
> Nancy
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>