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.
JMhttp://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
>

How to know if a job is running...

Howdy folks... just a quick question. Is there a system table that holds a variable that states if a job is currently running or not? Something like a status column for jobs. If so, where is it? and if not, any suggestions aside from setting a flag in a table when it runs and stops?
TIAha! Found my own answer... sp_help_job