Saturday, February 25, 2012

need ur help

hi all,
I was wondering how I can enforce some configurations to sql server
2000, like auditing failure logins for example, but without using the
enterprise manager.
I need to implement a tool that will set some configurations
automatically without human intervention, any idea how can i do
so''
thanx for time and helpQuick answer: You can do the configuration changes in Enterprise Manager
while being connected to the instance with SQL Profiler. That way you can
see what EM is doing on the DB and thereby you can reproduce that. But I'm
not sure if EM does everything by T-SQL or if it partly relies in DMO for
configuration. Question to the experts: In that case, would something show
up in the Profiler log?
Best regards
Nils Loeber
<Eng.Rana@.gmail.com> schrieb im Newsbeitrag
news:1154987176.155861.301430@.i42g2000cwa.googlegroups.com...
> hi all,
> I was wondering how I can enforce some configurations to sql server
> 2000, like auditing failure logins for example, but without using the
> enterprise manager.
> I need to implement a tool that will set some configurations
> automatically without human intervention, any idea how can i do
> so''
> thanx for time and help
>|||thanx for the gr8 help Nils.
i also found while searching the web, something called SQL-DMO, do u
think this may help or no
thanx again
[vbcol=seagreen]
>Nils Loeber wrote:
> Quick answer: You can do the configuration changes in Enterprise Manager
> while being connected to the instance with SQL Profiler. That way you can
> see what EM is doing on the DB and thereby you can reproduce that. But I'm
> not sure if EM does everything by T-SQL or if it partly relies in DMO for
> configuration. Question to the experts: In that case, would something show
> up in the Profiler log?
>
> Best regards
> Nils Loeber
>
> <Eng.Rana@.gmail.com> schrieb im Newsbeitrag
> news:1154987176.155861.301430@.i42g2000cwa.googlegroups.com...|||SQL-DMO is what I was referring to as DMO. Depending on what you want to do,
and with which programming language you want to do it, DMO might also be
well suited for the task.
Best regards
Nils Loeber
<Eng.Rana@.gmail.com> schrieb im Newsbeitrag
news:1155025512.608190.203300@.75g2000cwc.googlegroups.com...
> thanx for the gr8 help Nils.
> i also found while searching the web, something called SQL-DMO, do u
> think this may help or no
> thanx again
>
>

No comments:

Post a Comment