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 service. Show all posts
Showing posts with label service. 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
>
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 ?
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.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 ?
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.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 to tell which sp am i running on?
hi all,
how can i know what SPs (service packS) is my SQL server box currently
running
on
--
thanks,
--
joeySELECT SERVERPROPERTY('ProductLevel')
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joeydj" <Email me> wrote in message news:95BA09C5-60F2-466E-A1B5-1BE9776CA5D7@.microsoft.com...
> hi all,
> how can i know what SPs (service packS) is my SQL server box currently
> running
> on
> --
> thanks,
> --
> joey|||Run this
select serverproperty('ProductLevel')
Returns:
'RTM' = shipping version.
'SPn' = service pack version
'Bn', = beta version
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shahsql
how can i know what SPs (service packS) is my SQL server box currently
running
on
--
thanks,
--
joeySELECT SERVERPROPERTY('ProductLevel')
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joeydj" <Email me> wrote in message news:95BA09C5-60F2-466E-A1B5-1BE9776CA5D7@.microsoft.com...
> hi all,
> how can i know what SPs (service packS) is my SQL server box currently
> running
> on
> --
> thanks,
> --
> joey|||Run this
select serverproperty('ProductLevel')
Returns:
'RTM' = shipping version.
'SPn' = service pack version
'Bn', = beta version
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shahsql
how to tell which sp am i running on?
hi all,
how can i know what SPs (service packS) is my SQL server box currently
running
on
thanks,
joeySELECT SERVERPROPERTY('ProductLevel')
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joeydj" <Email me> wrote in message news:95BA09C5-60F2-466E-A1B5-1BE9776CA5D7@.microsoft.com
..
> hi all,
> how can i know what SPs (service packS) is my SQL server box currently
> running
> on
> --
> thanks,
> --
> joey|||Run this
select serverproperty('ProductLevel')
Returns:
'RTM' = shipping version.
'SPn' = service pack version
'Bn', = beta version
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah
how can i know what SPs (service packS) is my SQL server box currently
running
on
thanks,
joeySELECT SERVERPROPERTY('ProductLevel')
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joeydj" <Email me> wrote in message news:95BA09C5-60F2-466E-A1B5-1BE9776CA5D7@.microsoft.com
..
> hi all,
> how can i know what SPs (service packS) is my SQL server box currently
> running
> on
> --
> thanks,
> --
> joey|||Run this
select serverproperty('ProductLevel')
Returns:
'RTM' = shipping version.
'SPn' = service pack version
'Bn', = beta version
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah
How to tell which service pack of SQLCE is installed on the desktop
The title about says it all. For merge replication, I need to make sure the
service packs match up between SQL2000 and SQLCE. How do I tell which SQLCE
version is in?
IIRC check the folder C:\Program Files\Microsoft SQL Server CE
2.0\Redist\Server, the latest one should be there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||actually this is good up to sp2. After sp 2 you need to check the versions
of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
For sp 4 they are
sscesa20.dll 2.00.7331.0
sscerp20.dll 2.00.7331.0
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||Thanks Hilary; that's helpful.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLeiiSD7FHA.1032@.TK2MSFTNGP11.phx.gbl...
> actually this is good up to sp2. After sp 2 you need to check the versions
> of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
> For sp 4 they are
> sscesa20.dll 2.00.7331.0
> sscerp20.dll 2.00.7331.0
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
>
service packs match up between SQL2000 and SQLCE. How do I tell which SQLCE
version is in?
IIRC check the folder C:\Program Files\Microsoft SQL Server CE
2.0\Redist\Server, the latest one should be there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||actually this is good up to sp2. After sp 2 you need to check the versions
of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
For sp 4 they are
sscesa20.dll 2.00.7331.0
sscerp20.dll 2.00.7331.0
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||Thanks Hilary; that's helpful.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLeiiSD7FHA.1032@.TK2MSFTNGP11.phx.gbl...
> actually this is good up to sp2. After sp 2 you need to check the versions
> of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
> For sp 4 they are
> sscesa20.dll 2.00.7331.0
> sscerp20.dll 2.00.7331.0
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
>
how to tell SP level?
How can I tell what level of service pack is installed on
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria
Wednesday, March 21, 2012
How to tell what service patches are applied
I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...
Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/
|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus
|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...
Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/
|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus
|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>
How to tell what service patches are applied
I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> > on Windows NT 5.2 (Build 3790: Service Pack 1)
> Your SQL Server is SP3
> Markus
>sql
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> > on Windows NT 5.2 (Build 3790: Service Pack 1)
> Your SQL Server is SP3
> Markus
>sql
How to tell what service patches are applied
I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>
how to tell SP level?
How can I tell what level of service pack is installed on
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria
How to tell services account in SQL
I have remote servers and i need to determine which
service account is the SQL server running on ?
Anyone knows hot to do it
Thanks
AnupI know this can be done using WMI. There are probably several ways to do
this.
-Argenis
"anup" <anonymous@.discussions.microsoft.com> wrote in message
news:52db01c5235d$ebbf2330$a601280a@.phx.gbl...
> I have remote servers and i need to determine which
> service account is the SQL server running on ?
> Anyone knows hot to do it
> Thanks
> Anup|||Check this script out and yank out whatever you don't need.
http://www.eggheadcafe.com/articles/20030627e.asp
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"anup" <anonymous@.discussions.microsoft.com> wrote in message
news:52db01c5235d$ebbf2330$a601280a@.phx.gbl...
>I have remote servers and i need to determine which
> service account is the SQL server running on ?
> Anyone knows hot to do it
> Thanks
> Anup
service account is the SQL server running on ?
Anyone knows hot to do it
Thanks
AnupI know this can be done using WMI. There are probably several ways to do
this.
-Argenis
"anup" <anonymous@.discussions.microsoft.com> wrote in message
news:52db01c5235d$ebbf2330$a601280a@.phx.gbl...
> I have remote servers and i need to determine which
> service account is the SQL server running on ?
> Anyone knows hot to do it
> Thanks
> Anup|||Check this script out and yank out whatever you don't need.
http://www.eggheadcafe.com/articles/20030627e.asp
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"anup" <anonymous@.discussions.microsoft.com> wrote in message
news:52db01c5235d$ebbf2330$a601280a@.phx.gbl...
>I have remote servers and i need to determine which
> service account is the SQL server running on ?
> Anyone knows hot to do it
> Thanks
> Anup
Monday, March 12, 2012
How to sync database latest data with Analysis service
Hi,
I am creating sql server reports using analysis service(using cubes and dimensions).
After creation of cubes and dimensions for existing data I deployed it. Then I created reports on this data. Reports are generated properly for existing data.
But the report is not showing newly inserted data to database (latest data inserted after deploying analysis service). Did I miss anything? Or any new configuration required?
Newly added data is reflected in report when each time I process the cube and dimension and redeploying it. which is a manual process.
How to auto sync newly added data into database with cubes?
Any help would be appreciated.
Thanks
You can use the Synchronize Database Wizard by right-clicking on "Databases" in Object Explorer (SQL Server Management Studio)
See:
http://msdn2.microsoft.com/en-us/library/ms189349.aspx
Hope this helps,
Santi
|||HI,
This option Synchronizes one analysis service database with another.
But in my case analysis server database should be Synchronize with RDBMS database(sql server)
Thanks,
Deepak
|||Try proactive caching. In partition tab in cube builder, click Storage setting, and select enable proactive caching. You can apply this setting to partition, dimension, measure group and cube.Sunday, February 19, 2012
How to stop mssql
Hi.
I need to stop mssql service via command row.
How can I do?
Tnk,
Luca"Luca" <NOSPAMprong2k@.hotmail.com> wrote in message
news:chpn2i$rk7$1@.atlantis.cu.mi.it...
> Hi.
> I need to stop mssql service via command row.
I need to stop mssql service via command row.
How can I do?
Tnk,
Luca"Luca" <NOSPAMprong2k@.hotmail.com> wrote in message
news:chpn2i$rk7$1@.atlantis.cu.mi.it...
> Hi.
> I need to stop mssql service via command row.
net stop mssqlserver
or net stop mssqlserver /y
That will also stop the SQL Server agent w/o prompting.
(net stop sqlserveragent stops the agent.)
> How can I do?
> Tnk,
> Luca
how to stop conversing status?
Once my target service start to process, how can I stop the rest from running?
right now I'm looping sys.conversation_endpoints and run "END CONVERSATION @.dhValue"
Is there a simpler way to stop processing a service without interfering with other services?
I don't understand what you mean by "stopping the rest from running". If you want a way to stop an activated stored procedure from running, you could either kill the spid it is running on, or disable the queue which will cause it to abort.
Rushi
|||yes, that' s it.
thanks
Subscribe to:
Posts (Atom)