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