Using either activeX or dos commands is there a way find whether a specified filed in a particular location exists or not?
ThanksI solved my own problem. Check out this site (Just for info).
http://www.sqldts.com/default.aspx?211|||in dos:
if exist your_file_name_with_path goto process_file
Showing posts with label dos. Show all posts
Showing posts with label dos. Show all posts
Wednesday, March 7, 2012
Sunday, February 19, 2012
How to find all sql servers in a domain
At the DOS prompt enter "OSQL -L" The -L option show all the servers that
are broadcasting on the network.
"Rob" wrote:
> Hi,
> Is there a way to find all available SQL Servers in a particular domain or
> subnet?
> Thanks.
> - Rob.Hi,
Is there a way to find all available SQL Servers in a particular domain or
subnet?
Thanks.
- Rob.|||At the DOS prompt enter "OSQL -L" The -L option show all the servers that
are broadcasting on the network.
"Rob" wrote:
> Hi,
> Is there a way to find all available SQL Servers in a particular domain or
> subnet?
> Thanks.
> - Rob.|||ISQL /L from a machine that has the client tools installed or use SQL DMO.
Just be aware that within the server network utility you have the ability to
hide the server so this may not be conclusive.
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||ISQL /L from a machine that has the client tools installed or use SQL DMO.
Just be aware that within the server network utility you have the ability to
hide the server so this may not be conclusive.
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||osql /L will most likely not give you all the SQL servers in a domain unless
you have a tiny domain that has nothing routed and every machine is
broadcasting--an unlikely scenario.
The only reliable way I've found is to enumerate all the machines in a
domain and systematically test each machine for the presence of SQL server
instances.
Linchi
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||osql /L will most likely not give you all the SQL servers in a domain unless
you have a tiny domain that has nothing routed and every machine is
broadcasting--an unlikely scenario.
The only reliable way I've found is to enumerate all the machines in a
domain and systematically test each machine for the presence of SQL server
instances.
Linchi
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||You can query the registry on your severs to get a definative answer the pat
h
is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
This will list all instances installed on your server.
Ray
"Linchi Shea" wrote:
[vbcol=seagreen]
> osql /L will most likely not give you all the SQL servers in a domain unle
ss
> you have a tiny domain that has nothing routed and every machine is
> broadcasting--an unlikely scenario.
> The only reliable way I've found is to enumerate all the machines in a
> domain and systematically test each machine for the presence of SQL server
> instances.
> Linchi
> "Greg Larsen" wrote:
>|||You can query the registry on your severs to get a definative answer the pat
h
is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
This will list all instances installed on your server.
Ray
"Linchi Shea" wrote:
[vbcol=seagreen]
> osql /L will most likely not give you all the SQL servers in a domain unle
ss
> you have a tiny domain that has nothing routed and every machine is
> broadcasting--an unlikely scenario.
> The only reliable way I've found is to enumerate all the machines in a
> domain and systematically test each machine for the presence of SQL server
> instances.
> Linchi
> "Greg Larsen" wrote:
>
are broadcasting on the network.
"Rob" wrote:
> Hi,
> Is there a way to find all available SQL Servers in a particular domain or
> subnet?
> Thanks.
> - Rob.Hi,
Is there a way to find all available SQL Servers in a particular domain or
subnet?
Thanks.
- Rob.|||At the DOS prompt enter "OSQL -L" The -L option show all the servers that
are broadcasting on the network.
"Rob" wrote:
> Hi,
> Is there a way to find all available SQL Servers in a particular domain or
> subnet?
> Thanks.
> - Rob.|||ISQL /L from a machine that has the client tools installed or use SQL DMO.
Just be aware that within the server network utility you have the ability to
hide the server so this may not be conclusive.
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||ISQL /L from a machine that has the client tools installed or use SQL DMO.
Just be aware that within the server network utility you have the ability to
hide the server so this may not be conclusive.
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||osql /L will most likely not give you all the SQL servers in a domain unless
you have a tiny domain that has nothing routed and every machine is
broadcasting--an unlikely scenario.
The only reliable way I've found is to enumerate all the machines in a
domain and systematically test each machine for the presence of SQL server
instances.
Linchi
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||osql /L will most likely not give you all the SQL servers in a domain unless
you have a tiny domain that has nothing routed and every machine is
broadcasting--an unlikely scenario.
The only reliable way I've found is to enumerate all the machines in a
domain and systematically test each machine for the presence of SQL server
instances.
Linchi
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||You can query the registry on your severs to get a definative answer the pat
h
is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
This will list all instances installed on your server.
Ray
"Linchi Shea" wrote:
[vbcol=seagreen]
> osql /L will most likely not give you all the SQL servers in a domain unle
ss
> you have a tiny domain that has nothing routed and every machine is
> broadcasting--an unlikely scenario.
> The only reliable way I've found is to enumerate all the machines in a
> domain and systematically test each machine for the presence of SQL server
> instances.
> Linchi
> "Greg Larsen" wrote:
>|||You can query the registry on your severs to get a definative answer the pat
h
is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
This will list all instances installed on your server.
Ray
"Linchi Shea" wrote:
[vbcol=seagreen]
> osql /L will most likely not give you all the SQL servers in a domain unle
ss
> you have a tiny domain that has nothing routed and every machine is
> broadcasting--an unlikely scenario.
> The only reliable way I've found is to enumerate all the machines in a
> domain and systematically test each machine for the presence of SQL server
> instances.
> Linchi
> "Greg Larsen" wrote:
>
Subscribe to:
Posts (Atom)