Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thankshttp://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsout
h.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
Showing posts with label 2000how. Show all posts
Showing posts with label 2000how. Show all posts
Friday, March 23, 2012
How to tell which version is installed
Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thanks
http://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thanks
http://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
Subscribe to:
Posts (Atom)