patch management

Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.
use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:

> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>
|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote: