How to know what Version is Sql 2000

Hi Folks:
How does one determine what version and Service Pak level is SQL Server. We
have SBS 2003 and I am not sure what Service Paks have been applied.
Many thanks for your help.
JM
http://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JBM" <JBM@.nowhere.com> wrote in message news:e$llvXv0FHA.1264@.tk2msftngp13.phx.gbl...
> Hi Folks:
> How does one determine what version and Service Pak level is SQL Server. We
> have SBS 2003 and I am not sure what Service Paks have been applied.
> Many thanks for your help.
> JM
>
|||Open EM, right click on the servername select properties and look for
"Product version"
..194 is RTM
..760 is SP3
The rest of the specific build numbers can be seen in the link provided by
Tibor
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"JBM" <JBM@.nowhere.com> wrote in message
news:e$llvXv0FHA.1264@.tk2msftngp13.phx.gbl...
> Hi Folks:
> How does one determine what version and Service Pak level is SQL Server.
> We have SBS 2003 and I am not sure what Service Paks have been applied.
> Many thanks for your help.
> JM
>