osql -L

Can anyone suggest why two client PCs on the same network report different
lists of servers using osql -L ?
Nick.
BOL says the -L option 'Lists the locally configured servers and the names
of the servers broadcasting on the network.'
So... it could be that they really are on different subnets and yuo don't
realize it. But 'locally configured' servers is the more likely answer.
-L will show all server aliases hat are defined on the client using the
Client Network Utility. You probably have different lists there...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
> Can anyone suggest why two client PCs on the same network report different
> lists of servers using osql -L ?
> Nick.
|||My colleague and I had also discussed the possibility of different subnets
being an issue, but didn't have the tehcnical knowledge to sound out our
ideas so we moved on and in fact checked out the configs via the Client
Network Utility.
The only difference that we found was a single alias on his machine whereas
on mine the list is empty and yet there are 49 servers to be found. Maybe
there's a different list of which I'm unaware ?
Inspired by a reply to a similar post I knocked up a quick VB6 app to use
DMO and list the servers. Unsurprisingly, I got exactly the same list as with
osql -L.
However, several entries in my list differ from that when we use my
colleague's machine.
Still, at your suggestion I'll take a closer look at the configs, Biran -
many thanks for your help.
Regards, Nick.
"Brian Moran" wrote:

>
> BOL says the -L option 'Lists the locally configured servers and the names
> of the servers broadcasting on the network.'
> So... it could be that they really are on different subnets and yuo don't
> realize it. But 'locally configured' servers is the more likely answer.
> -L will show all server aliases hat are defined on the client using the
> Client Network Utility. You probably have different lists there...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
> news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
>
>
|||Brian, further to my initial reply to your post, we have found that it is
indeed a subnet thang. Our machines are on different subnets.
Thanks again.
Regards, Nick.
"Brian Moran" wrote:

>
> BOL says the -L option 'Lists the locally configured servers and the names
> of the servers broadcasting on the network.'
> So... it could be that they really are on different subnets and yuo don't
> realize it. But 'locally configured' servers is the more likely answer.
> -L will show all server aliases hat are defined on the client using the
> Client Network Utility. You probably have different lists there...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
> news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
>
>
|||You can get different results at different times from the same PC as
well due to server responses not coming back in time. OSQL -L is based
on UDP network broadcasts. There are different factors that play into
what you get back for results. You can find the issues listed at:
http://www.sqldev.net/misc/ListSQLSvr.htm
-Sue
On Thu, 4 Nov 2004 08:13:03 -0800, "Nick Stephens"
<NickStephens@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Brian, further to my initial reply to your post, we have found that it is
>indeed a subnet thang. Our machines are on different subnets.
>Thanks again.
>Regards, Nick.
>"Brian Moran" wrote:
|||Many thanks, Sue !
Nick.
"Sue Hoegemeier" wrote:

> You can get different results at different times from the same PC as
> well due to server responses not coming back in time. OSQL -L is based
> on UDP network broadcasts. There are different factors that play into
> what you get back for results. You can find the issues listed at:
> http://www.sqldev.net/misc/ListSQLSvr.htm
> -Sue
> On Thu, 4 Nov 2004 08:13:03 -0800, "Nick Stephens"
> <NickStephens@.discussions.microsoft.com> wrote:
>
>

OSQL

Creating a utility that will allow a user to run a query from a BAT file.
BUT the SQL client is not installed on all PCs. How can I modify this to
run, or what must I do in order for this to work from PCs with no SQL client
'
osql -E -S EXCEDE\EXCEDE -d excede_Reporting -q"EXIT(exec isp_SetCrPw %1)"Hi,
you would probably have to write your own application for this using
e.g. .NET. That should be quite easy, as the only thing would be to
have a argument parser in place, the rest is only some simply
SqlConnection and SqlCommand.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||That would be beyond my current abilities. I can write some very simple
scripts, and I have a mild understanding of some VB and .NET, But to write
my own code. Well I have no idea where to start. If you would like to help
and get me started I would greatly appreciate and enjoy the experience.
Thanks.
==============================================="Jens" <Jens@.sqlserver2005.de> wrote in message
news:1171392808.470036.289720@.j27g2000cwj.googlegroups.com...
> Hi,
> you would probably have to write your own application for this using
> e.g. .NET. That should be quite easy, as the only thing would be to
> have a argument parser in place, the rest is only some simply
> SqlConnection and SqlCommand.
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Lets take that offline and write me an Email.|||WANNABE;7269311 Wrote:
> That would be beyond my current abilities. I can write some very
> simple
> scripts, and I have a mild understanding of some VB and .NET, But to
> write
> my own code. Well I have no idea where to start. If you would like to
> help
> and get me started I would greatly appreciate and enjoy the
> experience.
> Thanks.
> ===============================================> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1171392808.470036.289720@.j27g2000cwj.googlegroups.com...
> > Hi,
> >
> > you would probably have to write your own application for this using
> > e.g. .NET. That should be quite easy, as the only thing would be to
> > have a argument parser in place, the rest is only some simply
> > SqlConnection and SqlCommand.
> >
> >
> > HTH, Jens K. Suessmeyer.
> >
> > --
> > http://www.sqlserver2005.de
> > --
> >
I have written an OSQL like replacement in C#/.Net 2.0. I am
having a wee bit of an issue though. If the SQL file to be run
has dynamic SQL in it (building SQL strings and then executing
them) then the command will fail - always. I think it has
something to do with the nesting of the quotes. Got any ideas
on what would be causing something like this?
Thanks
escher4096

OSQL

Creating a utility that will allow a user to run a query from a BAT file.
BUT the SQL client is not installed on all PCs. How can I modify this to
run, or what must I do in order for this to work from PCs with no SQL client
?
osql -E -S EXCEDE\EXCEDE -d excede_Reporting -q"EXIT(exec isp_SetCrPw %1)"
Hi,
you would probably have to write your own application for this using
e.g. .NET. That should be quite easy, as the only thing would be to
have a argument parser in place, the rest is only some simply
SqlConnection and SqlCommand.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||That would be beyond my current abilities. I can write some very simple
scripts, and I have a mild understanding of some VB and .NET, But to write
my own code. Well I have no idea where to start. If you would like to help
and get me started I would greatly appreciate and enjoy the experience.
Thanks.
===============================================
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1171392808.470036.289720@.j27g2000cwj.googlegr oups.com...
> Hi,
> you would probably have to write your own application for this using
> e.g. .NET. That should be quite easy, as the only thing would be to
> have a argument parser in place, the rest is only some simply
> SqlConnection and SqlCommand.
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
|||Lets take that offline and write me an Email.
|||

Quote:

Originally Posted by WANNABE

That would be beyond my current abilities. I can write some very simple
scripts, and I have a mild understanding of some VB and .NET, But to write
my own code. Well I have no idea where to start. If you would like to help
and get me started I would greatly appreciate and enjoy the experience.
Thanks.
===============================================
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1171392808.470036.289720@.j27g2000cwj.googlegr oups.com...
> Hi,
> you would probably have to write your own application for this using
> e.g. .NET. That should be quite easy, as the only thing would be to
> have a argument parser in place, the rest is only some simply
> SqlConnection and SqlCommand.
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

I have written an OSQL like replacement in C#/.Net 2.0. I am
having a wee bit of an issue though. If the SQL file to be run
has dynamic SQL in it (building SQL strings and then executing
them) then the command will fail - always. I think it has
something to do with the nesting of the quotes. Got any ideas
on what would be causing something like this?
Thanks

OSQL

Creating a utility that will allow a user to run a query from a BAT file.
BUT the SQL client is not installed on all PCs. How can I modify this to
run, or what must I do in order for this to work from PCs with no SQL client
'
osql -E -S EXCEDE\EXCEDE -d excede_Reporting -q"EXIT(exec isp_SetCrPw %1)"Hi,
you would probably have to write your own application for this using
e.g. .NET. That should be quite easy, as the only thing would be to
have a argument parser in place, the rest is only some simply
SqlConnection and SqlCommand.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||That would be beyond my current abilities. I can write some very simple
scripts, and I have a mild understanding of some VB and .NET, But to write
my own code. Well I have no idea where to start. If you would like to help
and get me started I would greatly appreciate and enjoy the experience.
Thanks.
========================================
=======
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1171392808.470036.289720@.j27g2000cwj.googlegroups.com...
> Hi,
> you would probably have to write your own application for this using
> e.g. .NET. That should be quite easy, as the only thing would be to
> have a argument parser in place, the rest is only some simply
> SqlConnection and SqlCommand.
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Lets take that offline and write me an Email.|||WANNABE;7269311 Wrote:[vbcol=seagreen]
> That would be beyond my current abilities. I can write some very
> simple
> scripts, and I have a mild understanding of some VB and .NET, But to
> write
> my own code. Well I have no idea where to start. If you would like to
> help
> and get me started I would greatly appreciate and enjoy the
> experience.
> Thanks.
> ========================================
=======
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1171392808.470036.289720@.j27g2000cwj.googlegroups.com...
I have written an OSQL like replacement in C#/.Net 2.0. I am
having a wee bit of an issue though. If the SQL file to be run
has dynamic SQL in it (building SQL strings and then executing
them) then the command will fail - always. I think it has
something to do with the nesting of the quotes. Got any ideas
on what would be causing something like this?
Thanks
escher4096

OS requirements for 2005.

Howdy all. Im considering buying a new home PC, and would like to install
the developer edition of SQL 2005 once I have it. Most new PC's that Im
looking at have either WIN XP Home or Media Center. I see the requirements
for SQL 2005 here:
http://www.microsoft.com/sql/editions/developer/sysreqs.mspx
but it doesnt say specifically if these versions of the OS will work or not.
I know it will install fine on XP Pro, but Id like to avoid the purchase
upgrade if possible. Can someone please assist?
TIA, CFR
Thanks for the speedy response!
"Theo Verweij" <tverweij@.xs4all.nl> wrote in message
news:eAdEHPCAHHA.4348@.TK2MSFTNGP04.phx.gbl...[vbcol=seagreen]
> Home and Media Centre does not have an IIS aboard. So all functionality
> (like reporting services, http endpoinds, etc) that need IIS won't work
> with these versions.
> To use all functions in SQL, you need a pro or a server.
> ChrisR wrote:
install[vbcol=seagreen]
requirements[vbcol=seagreen]
not.[vbcol=seagreen]
|||You will need SP2 for Home Edition.
And if you want to do development that requires IIS, this article may help.
Installing IIS on Windows XP Home Edition
http://www.webthang.co.uk/Tuts/tuts_server/iis_xph/pippo_xp.asp
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"ChrisR" <noFudgingWay@.NoEmail.com> wrote in message
news:%23c%23WZMCAHHA.4428@.TK2MSFTNGP04.phx.gbl...
> Howdy all. Im considering buying a new home PC, and would like to install
> the developer edition of SQL 2005 once I have it. Most new PC's that Im
> looking at have either WIN XP Home or Media Center. I see the requirements
> for SQL 2005 here:
> http://www.microsoft.com/sql/editions/developer/sysreqs.mspx
> but it doesnt say specifically if these versions of the OS will work or
> not.
> I know it will install fine on XP Pro, but Id like to avoid the purchase
> upgrade if possible. Can someone please assist?
> TIA, CFR
>