OSQL output

Hi,
I run a script on all of our SQL Servers (+300 servers) on a regular basis
to collect information about different instances, version, port and so on
for each SQL Server using a loop than runs OSQL and passes a query to it for
each member server. The passed query then collects this information on each
server and saves the results in main server using OPENROWSET.
Due to different SQL Server and MDAC versions on each member SQL server,
sometimes OPENROWSET fails to saves its results.
Is there a way to get the output of the OSQL as tabular values so I can pass
the query (without OPENROWSET inside the query) using OSQL, get the results
in tabular format (like a table) and then save the results in main table.
This way, I will avoid using costly OPENROWSET.
My main server is SQL Server 2000 SP4 and we have different range of SQL
Servers and SPs.
Thanks> Is there a way to get the output of the OSQL as tabular values so I can pass
> the query (without OPENROWSET inside the query) using OSQL, get the results
> in tabular format (like a table) and then save the results in main table.
The output of osql.exe is text. You typically need an intermediate
program/script to parse it and reformat it before feeding the result into a
table(s).
Linchi
"Alex" wrote:
> Hi,
> I run a script on all of our SQL Servers (+300 servers) on a regular basis
> to collect information about different instances, version, port and so on
> for each SQL Server using a loop than runs OSQL and passes a query to it for
> each member server. The passed query then collects this information on each
> server and saves the results in main server using OPENROWSET.
> Due to different SQL Server and MDAC versions on each member SQL server,
> sometimes OPENROWSET fails to saves its results.
> Is there a way to get the output of the OSQL as tabular values so I can pass
> the query (without OPENROWSET inside the query) using OSQL, get the results
> in tabular format (like a table) and then save the results in main table.
> This way, I will avoid using costly OPENROWSET.
> My main server is SQL Server 2000 SP4 and we have different range of SQL
> Servers and SPs.
> Thanks
>
>

OS Service pack

Is there a way from within a SQL Script to determine what OS service
pack is installed other than SELECT @.@.VERSION? I am trying to
automate a script based upon the OS service pack installed (if any),
and having to somehow parse the results of @.@.VERSION seems unreliable.
Any ideas?
Brandon
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)Have a look at SERVERPROPERTY and xp_msver.
Off the top of my head I think you need to run :- xp_msver windowsversion
--
HTH
Ryan Waight, MCDBA, MCSE
"Brandon Lilly" <brandon.lilly@.nospam_medevolve.com> wrote in message
news:eZw5EB3kDHA.3612@.TK2MSFTNGP11.phx.gbl...
> Is there a way from within a SQL Script to determine what OS service
> pack is installed other than SELECT @.@.VERSION? I am trying to
> automate a script based upon the OS service pack installed (if any),
> and having to somehow parse the results of @.@.VERSION seems unreliable.
> Any ideas?
> Brandon
> --
> "In the beginning the universe was created. This has made a lot of
> people very angry, and has been widely regarded as a bad move." -
> Douglas Noel Adams (1952-2001)
>|||You can get the OS information by running the
xp_msver 'WindowsVersion' extended stored procedure.
Like so...
CREATE TABLE #windows_info
(
idx INT
, name NVARCHAR(128)
, internal_value INT
, character_value NVARCHAR(255)
)
INSERT #windows_info
EXECUTE xp_msver 'WindowsVersion'
SELECT * FROM #windows_info
I don't know if this is easier than parsing the @.@.VERSION
string though.
Tim
>--Original Message--
>Is there a way from within a SQL Script to determine
what OS service
>pack is installed other than SELECT @.@.VERSION? I am
trying to
>automate a script based upon the OS service pack
installed (if any),
>and having to somehow parse the results of @.@.VERSION
seems unreliable.
>Any ideas?
>Brandon
>--
>"In the beginning the universe was created. This has
made a lot of
>people very angry, and has been widely regarded as a bad
move." -
>Douglas Noel Adams (1952-2001)
>
>.
>|||You can get it from the registry, using the undocumented
xp_regread. Try:
exec
master..xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsof
t\Windows NT\CurrentVersion', 'CSDVersion'
If your OS is NT 4, this won't distinguish between SP6 and
SP6a.
HTH
Vern
>--Original Message--
>Is there a way from within a SQL Script to determine what
OS service
>pack is installed other than SELECT @.@.VERSION? I am
trying to
>automate a script based upon the OS service pack
installed (if any),
>and having to somehow parse the results of @.@.VERSION
seems unreliable.
>Any ideas?
>Brandon
>--
>"In the beginning the universe was created. This has
made a lot of
>people very angry, and has been widely regarded as a bad
move." -
>Douglas Noel Adams (1952-2001)
>
>.
>

OS requirements for MSSQL2K5.

Can 2005 be installed on XP Media Center Edition? I looked on the SQL site,
but it only references Windows XP, not this particular version.
TIA, ChrisR"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:368FB023-9CEA-493B-A939-D941E6561F96@.microsoft.com...
> Can 2005 be installed on XP Media Center Edition? I looked on the SQL
> site,
> but it only references Windows XP, not this particular version.
Yes. I have it on my laptop. Make sure you have at least 1 gig of ram.|||Do you know of any links regarding this matter? Its not that I don't believe
you, it's just that I want to buy a new computer for home and this is the OS
most of them come with these days.
"_Stephen" wrote:

> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:368FB023-9CEA-493B-A939-D941E6561F96@.microsoft.com...
> Yes. I have it on my laptop. Make sure you have at least 1 gig of ram.
>
>|||"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:368FB023-9CEA-493B-A939-D941E6561F96@.microsoft.com...
> Can 2005 be installed on XP Media Center Edition? I looked on the SQL
> site,
> but it only references Windows XP, not this particular version.
Yes. I have it on my laptop. Make sure you have at least 1 gig of ram.|||Do you know of any links regarding this matter? Its not that I don't believe
you, it's just that I want to buy a new computer for home and this is the OS
most of them come with these days.
"_Stephen" wrote:

> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:368FB023-9CEA-493B-A939-D941E6561F96@.microsoft.com...
> Yes. I have it on my laptop. Make sure you have at least 1 gig of ram.
>
>|||"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:6BC0D546-6DD1-41A5-9EFB-03118F207EDB@.microsoft.com...
> Do you know of any links regarding this matter? Its not that I don't
> believe
> you, it's just that I want to buy a new computer for home and this is the
> OS
> most of them come with these days.
Media Center is XP Pro with better entertainment media capabilities.|||"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:6BC0D546-6DD1-41A5-9EFB-03118F207EDB@.microsoft.com...
> Do you know of any links regarding this matter? Its not that I don't
> believe
> you, it's just that I want to buy a new computer for home and this is the
> OS
> most of them come with these days.
Media Center is XP Pro with better entertainment media capabilities.

OS requirements for MSSQL2K5.

Can 2005 be installed on XP Media Center Edition? I looked on the SQL site,
but it only references Windows XP, not this particular version.
TIA, ChrisR"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:368FB023-9CEA-493B-A939-D941E6561F96@.microsoft.com...
> Can 2005 be installed on XP Media Center Edition? I looked on the SQL
> site,
> but it only references Windows XP, not this particular version.
Yes. I have it on my laptop. Make sure you have at least 1 gig of ram.|||Do you know of any links regarding this matter? Its not that I don't believe
you, it's just that I want to buy a new computer for home and this is the OS
most of them come with these days.
"_Stephen" wrote:
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:368FB023-9CEA-493B-A939-D941E6561F96@.microsoft.com...
> > Can 2005 be installed on XP Media Center Edition? I looked on the SQL
> > site,
> > but it only references Windows XP, not this particular version.
> Yes. I have it on my laptop. Make sure you have at least 1 gig of ram.
>
>|||"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:6BC0D546-6DD1-41A5-9EFB-03118F207EDB@.microsoft.com...
> Do you know of any links regarding this matter? Its not that I don't
> believe
> you, it's just that I want to buy a new computer for home and this is the
> OS
> most of them come with these days.
Media Center is XP Pro with better entertainment media capabilities.

OS requirements for 2005.

Can 2005 be installed on XP Media Center Edition? I looked on the SQL site,
but it only references Windows XP, not this particular version. Any whitepapers, links, etc., would be especially appreciated.
TIA, ChrisRFound it...

http://support.microsoft.com/?scid=kb;en-us;910228&spid=2855&sid=312#E03W0ABAAA