I am a vb6 programmer with a moderate working knowledge of SQL and absolutely no knowledge of XML.
I am working on a project that will log a bunch of information about a machine (processor, ram, all installed software, ip address, login info, etc), and I was thinking of storing it in an xml format in SQL Server. I figured this would work well because the information gathered may change from month to month. It also gives me an opportunity to work with SQL Server and XML.
So my basic question is, will this work and still allow me to search the data for specific elements? I was thinking of the following XML format.