how can I confirm msde sp3a upgrade information

I would need to know if the MSDE SP3a is aleady Upgraded.
I didn't search registy and Enterprise Manager(other PC)
Thank for your help
Hi,
Login to sql server using below command from command prompt:-
OSQL -sa -Ppassword -Sserver_name (enter)
1>select serverproperty('productlevel')
2>go
This will give you the service pack level of your sql server.
For older versions < SQL 2000, use the command
select @.@.version
It will give you the service pack number. with you can check the below link
to get the service pack details.
http://vyaskn.tripod.com/sqlsps.htm
Thanks
Hari
MCDBA
"peter" <anonymous@.discussions.microsoft.com> wrote in message
news:62a701c47528$ec661070$a301280a@.phx.gbl...
> I would need to know if the MSDE SP3a is aleady Upgraded.
> I didn't search registy and Enterprise Manager(other PC)
> Thank for your help
|||http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"peter" <anonymous@.discussions.microsoft.com> wrote in message
news:62a701c47528$ec661070$a301280a@.phx.gbl...
> I would need to know if the MSDE SP3a is aleady Upgraded.
> I didn't search registy and Enterprise Manager(other PC)
> Thank for your help