automated change config notifications

There is a company, Idera http://idera.com/Products/SQLconfig/ that produces
a product called SQLconfig. Among other things, it monitors database server
hardware, operating system (OS), SQL Server instance and database
configuration, providing both automated change notification and comprehensiv
e
reporting on changes in a SQL Server environment
Does anyone know of any VBS or T-SQL that can be used instead? Any info,
links would be appreciated to get started on this project. Thank you.Well www.red-gate.com has a product with a development kit that gives you an
API to do these kinds of things programmatically.
Andrew J. Kelly SQL MVP
"SQLcat" <SQLcat@.discussions.microsoft.com> wrote in message
news:362547A2-43E0-409B-9E82-45D9428E2D9F@.microsoft.com...
> There is a company, Idera http://idera.com/Products/SQLconfig/ that
> produces
> a product called SQLconfig. Among other things, it monitors database
> server
> hardware, operating system (OS), SQL Server instance and database
> configuration, providing both automated change notification and
> comprehensive
> reporting on changes in a SQL Server environment
> Does anyone know of any VBS or T-SQL that can be used instead? Any info,
> links would be appreciated to get started on this project. Thank you.|||I'd also like to get away from trial versions of software. I'd like to be
able to do this in house.
"Andrew J. Kelly" wrote:

> Well www.red-gate.com has a product with a development kit that gives you
an
> API to do these kinds of things programmatically.
> --
> Andrew J. Kelly SQL MVP
>
> "SQLcat" <SQLcat@.discussions.microsoft.com> wrote in message
> news:362547A2-43E0-409B-9E82-45D9428E2D9F@.microsoft.com...
>
>|||Then why not buy the tool? It's only a few hundred dollars. You will waste
that much in your own time in a few hours.
Andrew J. Kelly SQL MVP
"SQLcat" <SQLcat@.discussions.microsoft.com> wrote in message
news:2F604881-2008-4A83-A83D-1F8FC7A2DF52@.microsoft.com...
> I'd also like to get away from trial versions of software. I'd like to be
> able to do this in house.
> "Andrew J. Kelly" wrote:
>|||a few hours I have....
"Andrew J. Kelly" wrote:

> Then why not buy the tool? It's only a few hundred dollars. You will was
te
> that much in your own time in a few hours.
> --
> Andrew J. Kelly SQL MVP
>
> "SQLcat" <SQLcat@.discussions.microsoft.com> wrote in message
> news:2F604881-2008-4A83-A83D-1F8FC7A2DF52@.microsoft.com...
>
>|||So if you are doing this for fun rather than profit why are you asking
for us to show you ... :-)
You'll perhaps want to look at WMI and DMO for this. DMO gives access
to SQL Server objects and allows you to script them. However, DMO is
superceded by SMO in 2005 so now probably isn't a good time to embark
on such a project. One reason why most people don't write system
management tools is because of the cost of keeping up with the
technology.
David Portas
SQL Server MVP
--|||I'll look into the DMO route...we're not going to SQL 2005 anytime soon, so
hopefully SMO won't be an issue for some time. This will "profit" my compan
y
and my ability to keep on top of changes as they occur....good and bad.
Just Google SQL DMO and go from there?
"David Portas" wrote:

> So if you are doing this for fun rather than profit why are you asking
> for us to show you ... :-)
> You'll perhaps want to look at WMI and DMO for this. DMO gives access
> to SQL Server objects and allows you to script them. However, DMO is
> superceded by SMO in 2005 so now probably isn't a good time to embark
> on such a project. One reason why most people don't write system
> management tools is because of the cost of keeping up with the
> technology.
> --
> David Portas
> SQL Server MVP
> --
>