How to find what SQL 2000 service pack is running?

Hey everyone,
We are running SQL 2000 and I just want to know how to find what service
pack is installed and running on the system.
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
http://support.microsoft.com/kb/321185/
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Clayton Sutton" <none@.none.com> wrote in message
news:JxOQh.216567$Jt2.120445@.fe04.news.easynews.co m...
> Hey everyone,
> We are running SQL 2000 and I just want to know how to find what service
> pack is installed and running on the system.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
>
|||Thanks Aaron, that did the trick!
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eHyPAdsdHHA.3960@.TK2MSFTNGP02.phx.gbl...
> http://support.microsoft.com/kb/321185/
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Clayton Sutton" <none@.none.com> wrote in message
> news:JxOQh.216567$Jt2.120445@.fe04.news.easynews.co m...
>

How to find what SQL 2000 service pack is running?

Hey everyone,
We are running SQL 2000 and I just want to know how to find what service
pack is installed and running on the system.
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************http://support.microsoft.com/kb/321185/
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Clayton Sutton" <none@.none.com> wrote in message
news:JxOQh.216567$Jt2.120445@.fe04.news.easynews.com...
> Hey everyone,
> We are running SQL 2000 and I just want to know how to find what service
> pack is installed and running on the system.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
>|||Thanks Aaron, that did the trick!
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:eHyPAdsdHHA.3960@.TK2MSFTNGP02.phx.gbl...
> http://support.microsoft.com/kb/321185/
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Clayton Sutton" <none@.none.com> wrote in message
> news:JxOQh.216567$Jt2.120445@.fe04.news.easynews.com...
>sql

How to find what SQL 2000 service pack is running?

Hey everyone,
We are running SQL 2000 and I just want to know how to find what service
pack is installed and running on the system.
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************http://support.microsoft.com/kb/321185/
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Clayton Sutton" <none@.none.com> wrote in message
news:JxOQh.216567$Jt2.120445@.fe04.news.easynews.com...
> Hey everyone,
> We are running SQL 2000 and I just want to know how to find what service
> pack is installed and running on the system.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
>|||Thanks Aaron, that did the trick!
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eHyPAdsdHHA.3960@.TK2MSFTNGP02.phx.gbl...
> http://support.microsoft.com/kb/321185/
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Clayton Sutton" <none@.none.com> wrote in message
> news:JxOQh.216567$Jt2.120445@.fe04.news.easynews.com...
>> Hey everyone,
>> We are running SQL 2000 and I just want to know how to find what service
>> pack is installed and running on the system.
>> --
>> TIA,
>>
>> Clayton
>>
>> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
>> You can find it at: http://www.nikoli.net/itunepod
>> *******************
>>
>>
>

How to find version of Sql and Service Pack?

How can I find out what version of sql is installed
and what is the service pack?
Thank you,
-Mehttp://www.aspfaq.com/2160
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Me" <anonymous@.discussions.microsoft.com> wrote in message
news:9b4f01c4974b$c7968b90$a301280a@.phx.gbl...
> How can I find out what version of sql is installed
> and what is the service pack?
> Thank you,
> -Me|||select @.@.version
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185&sd=tech
--
erik perez
www.solien.com
"Me" <anonymous@.discussions.microsoft.com> wrote in message
news:9b4f01c4974b$c7968b90$a301280a@.phx.gbl...
> How can I find out what version of sql is installed
> and what is the service pack?
> Thank you,
> -Me|||Thank you Aaron, I was used to using @.@.version, but now
they have changed it.
-Me
>--Original Message--
>http://www.aspfaq.com/2160
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Me" <anonymous@.discussions.microsoft.com> wrote in
message
>news:9b4f01c4974b$c7968b90$a301280a@.phx.gbl...
>> How can I find out what version of sql is installed
>> and what is the service pack?
>> Thank you,
>> -Me
>
>.
>|||Thank you Erik.
-Me
>--Original Message--
>select @.@.version
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;321185&sd=tech
>--
>erik perez
>www.solien.com
>"Me" <anonymous@.discussions.microsoft.com> wrote in
message
>news:9b4f01c4974b$c7968b90$a301280a@.phx.gbl...
>> How can I find out what version of sql is installed
>> and what is the service pack?
>> Thank you,
>> -Me
>
>.
>

How to find SQL Server machine configration

I have SQL Server client installed on my machine, through which I connect to SQL Server A. Is there any way, in which I can find out the configration of the machine on which SQL Server A is installed. I am interested in finding out the number of processors and the amount of RAM.

If you're using SQL Server 2005 and have sysadmin privileges or more specifically the VIEW_SERVER_STATE permission you can run the following command:

SELECT * FROM sys.dm_os_sys_info

You can see [cpu_count] and [hyperthread_ratio] as well as [physical_memory_in_bytes]

For more information, please check out the Books Online documentation: http://msdn2.microsoft.com/en-us/library/ms175048.aspx.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Hi Paul,

Thanks for the info.

But I am currently trying to find the machine config of SQL Server 2000. Is there a equivalent query for that. Sorry I didn't specify the SQL Server version in the previous post.

|||

You should upgrade :-P

For SQL Server 2000, I'm not sure. Have you tried EXEC xp_msver?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

EXEC xp_msver gives me the processor count and the processor type.

I think I can go ahead from there. Thanks

how to find out what sqlserver i am running

Hi
I am taking over a existing sqlserver
The sqlserver is working fine
Is there a way to find out whether the prev guy installed
sqlserver standard edition o
sqlserver developer edition o
sqlserver personal editio
may b
from registry or active log msg during boot up or
using select @.@.version from system table etc
thanks a million for your valuable time to answerMike,
If you check the output of SELECT @.@.VERSION , it would mention the SQLServer
edition in the last line.For example, I see:
...
"Enterprise Edition on Windows ..."
Or you can simply do SELECT SERVERPROPERTY('EDITION')
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:CFA71390-27A4-407B-9232-A4BDE3F9E856@.microsoft.com...
> Hi:
> I am taking over a existing sqlserver.
> The sqlserver is working fine.
> Is there a way to find out whether the prev guy installed
> sqlserver standard edition or
> sqlserver developer edition or
> sqlserver personal edition
> may be
> from registry or active log msg during boot up or
> using select @.@.version from system table etc.
>
> thanks a million for your valuable time to answer.
>|||http://www.aspfaq.com/2160
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:CFA71390-27A4-407B-9232-A4BDE3F9E856@.microsoft.com...
> Hi:
> I am taking over a existing sqlserver.
> The sqlserver is working fine.
> Is there a way to find out whether the prev guy installed
> sqlserver standard edition or
> sqlserver developer edition or
> sqlserver personal edition
> may be
> from registry or active log msg during boot up or
> using select @.@.version from system table etc.
>
> thanks a million for your valuable time to answer.
>

How to find out SP2 is installed ?

Is there any easy way to find out SP2 is installed on the
Server ?
ThanksCalling http://servername/Reportserver will show you the Version of the
Reporting service:
original installation 8.00.743.00
SP1 is Version 8.00.878.00
SP2 is Version 8.00.1038.00
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Jason" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:05a001c56b2f$2d522400$a501280a@.phx.gbl...
> Is there any easy way to find out SP2 is installed on the
> Server ?
> Thanks

How to find out Reporting Services is installed ?

Is there any easy way to find out whether Reporting Services has been
installed on a SQL 2000 Server ?
Thanks
Peterhttp://servername/ReportServer
If it's installed this will show you version information.
Reporting Services creates x2 new databases, ReportServer and
ReportServerTempDB if these exist thats a good indication also.
--
HTH. Ryan
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:ODmuIvsEHHA.996@.TK2MSFTNGP02.phx.gbl...
> Is there any easy way to find out whether Reporting Services has been
> installed on a SQL 2000 Server ?
> Thanks
> Peter
>

how to find out licenses installed

I have a SQL server and would like to konw what kind of licensing it is
using , how can i find out? Thanks.Hi,
FOR SQL 2000, Execute the below script:-
select serverproperty('LicenseType') as Licence_type
go
select serverproperty('NumLicenses') as Num_of_licences
For SQL 7 and Older versions:-
1. Go to COntrol Panel..
2. Double click above the licences and select the SQL Server License.
3. This will show you the type of license and count.
Thanks
Hari
MCDBA
"john" <john@.aicinc.com> wrote in message
news:uNjGb$KYEHA.384@.TK2MSFTNGP10.phx.gbl...
> I have a SQL server and would like to konw what kind of licensing it is
> using , how can i find out? Thanks.
>

how to find out licenses installed

I have a SQL server and would like to konw what kind of licensing it is
using , how can i find out? Thanks.
Hi,
FOR SQL 2000, Execute the below script:-
select serverproperty('LicenseType') as Licence_type
go
select serverproperty('NumLicenses') as Num_of_licences
For SQL 7 and Older versions:-
1. Go to COntrol Panel..
2. Double click above the licences and select the SQL Server License.
3. This will show you the type of license and count.
Thanks
Hari
MCDBA
"john" <john@.aicinc.com> wrote in message
news:uNjGb$KYEHA.384@.TK2MSFTNGP10.phx.gbl...
> I have a SQL server and would like to konw what kind of licensing it is
> using , how can i find out? Thanks.
>

how to find out licenses installed

I have a SQL server and would like to konw what kind of licensing it is
using , how can i find out? Thanks.Hi,
FOR SQL 2000, Execute the below script:-
select serverproperty('LicenseType') as Licence_type
go
select serverproperty('NumLicenses') as Num_of_licences
For SQL 7 and Older versions:-
1. Go to COntrol Panel..
2. Double click above the licences and select the SQL Server License.
3. This will show you the type of license and count.
Thanks
Hari
MCDBA
"john" <john@.aicinc.com> wrote in message
news:uNjGb$KYEHA.384@.TK2MSFTNGP10.phx.gbl...
> I have a SQL server and would like to konw what kind of licensing it is
> using , how can i find out? Thanks.
>

How to find of which ver of sqlreporting i am using

ie i want to know whether sp2 is installed or not
please helpHi,
Browse to http://<Server Name>/Reportserver
Check version number at bottom of list. 8.00.1038.00 is SP2.
"sqlReport sqlReport via SQLMonster.com" wrote:
> ie i want to know whether sp2 is installed or not
> please help
>