change configuration notification process

I need to implement an automated change configuration notification process
for all my current SQL server configurations. I don't know if SQL-DMO is the
way to go here, but I certainly do not know enough about it to be proficient.
Any web links and info would be greatly appreciated.
All SQL boxes are of the 2000 variety.
SQLcat,
Could you define your requirements more clearly? What do you mean by
"automated change configuration notification process". What changes do you
need to monitor? Schema, security, data, etc?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"SQLcat" wrote:

> I need to implement an automated change configuration notification process
> for all my current SQL server configurations. I don't know if SQL-DMO is the
> way to go here, but I certainly do not know enough about it to be proficient.
> Any web links and info would be greatly appreciated.
> All SQL boxes are of the 2000 variety.
|||sorry...I'm interested in ensuring the server side configuration settings
remain the same across the board and that if anyone other than myself has
made a change, I'd be notified...perhaps this would fall under security?
"Mark Allison" wrote:
[vbcol=seagreen]
> SQLcat,
> Could you define your requirements more clearly? What do you mean by
> "automated change configuration notification process". What changes do you
> need to monitor? Schema, security, data, etc?
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
>
> "SQLcat" wrote:
|||in thinking about this a little further, I guess if I had the results of
sp_configure for each SQL server in my environment, I could compare the
results daily to see if any server side changes occurred....while it would
be nice to determine who would've changed what, the aforementioned will be a
good start....how could I get something like sp_configure to give me server
side results for all my SQL boxes without having to go to each box and run it
in QA?
"Mark Allison" wrote:
[vbcol=seagreen]
> SQLcat,
> Could you define your requirements more clearly? What do you mean by
> "automated change configuration notification process". What changes do you
> need to monitor? Schema, security, data, etc?
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
>
> "SQLcat" wrote:

Case-Sensitive Search

Hi,
We have two systems, a Financial system and a Professional Service Automated
system. The database currently has a collation of case-insensitive
(MSSQL2K). The Financial system happened to have incorrectly exported a
ProjectCode value that was in all lower case to the other system where in
expects a ProjectCode value to be in UPPERCASE. I would to be able to write
a query that will identify all rows in a table in the financial system where
the ProjectCode is in lowercase in the case-insensitive environment.
TIA,
bpdeeSee "collate" clause in BOL.
Example:
select
*
from
(
select 1, cast('microsoft sql server 2000' as varchar(25))
union all
select 2, cast('MICROSOFT SQL SERVER 2000' as varchar(25))
) t1(c1, c2)
where
c2 like 'microsoft sql server 2000' collate SQL_Latin1_General_CP1_CS_AS
AMB
"bpdee" wrote:
> Hi,
> We have two systems, a Financial system and a Professional Service Automated
> system. The database currently has a collation of case-insensitive
> (MSSQL2K). The Financial system happened to have incorrectly exported a
> ProjectCode value that was in all lower case to the other system where in
> expects a ProjectCode value to be in UPPERCASE. I would to be able to write
> a query that will identify all rows in a table in the financial system where
> the ProjectCode is in lowercase in the case-insensitive environment.
> TIA,
> bpdee