How to get SQL Server Service Pack information

Hi,
The below result i get from running xp_msver, but is this information
showing any SQL service pack information?
How can i get it?
1,ProductName,NULL,Microsoft SQL Server
2,ProductVersion,524288,8.00.760
3,Language,1033,English (United States)
4,Platform,NULL,NT INTEL X86
5,Comments,NULL,NT INTEL X86
6,CompanyName,NULL,Microsoft Corporation
7,FileDescription,NULL,SQL Server Windows NT
8,FileVersion,NULL,2000.080.0760.00
9,InternalName,NULL,SQLSERVR
10,LegalCopyright,NULL,© 1988-2003 Microsoft Corp. All rights reserved.
11,LegalTrademarks,NULL,Microsoft® is a registered trademark of Microsoft
Corporation. Windows(TM) is a trademark of Microsoft Corporation
12,OriginalFilename,NULL,SQLSERVR.EXE
13,PrivateBuild,NULL,NULL
14,SpecialBuild,49807360,NULL
15,WindowsVersion,143851525,5.0 (2195)
16,ProcessorCount,1,1
17,ProcessorActiveMask,1,00000001
18,ProcessorType,586,PROCESSOR_INTEL_PENTIUM
19,PhysicalMemory,511,511 (536264704)
20,Product ID,NULL,NULL
--
Kzeto NgHi,
From the output the service pack level for your SQL Server is SP3 (
2,ProductVersion,524288,8.00.760 )
Thanks
Hari
MCDBA
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:ev9prZIuDHA.3220@.tk2msftngp13.phx.gbl...
> Hi,
> The below result i get from running xp_msver, but is this information
> showing any SQL service pack information?
> How can i get it?
>
> 1,ProductName,NULL,Microsoft SQL Server
> 2,ProductVersion,524288,8.00.760
> 3,Language,1033,English (United States)
> 4,Platform,NULL,NT INTEL X86
> 5,Comments,NULL,NT INTEL X86
> 6,CompanyName,NULL,Microsoft Corporation
> 7,FileDescription,NULL,SQL Server Windows NT
> 8,FileVersion,NULL,2000.080.0760.00
> 9,InternalName,NULL,SQLSERVR
> 10,LegalCopyright,NULL,© 1988-2003 Microsoft Corp. All rights reserved.
> 11,LegalTrademarks,NULL,Microsoft® is a registered trademark of Microsoft
> Corporation. Windows(TM) is a trademark of Microsoft Corporation
> 12,OriginalFilename,NULL,SQLSERVR.EXE
> 13,PrivateBuild,NULL,NULL
> 14,SpecialBuild,49807360,NULL
> 15,WindowsVersion,143851525,5.0 (2195)
> 16,ProcessorCount,1,1
> 17,ProcessorActiveMask,1,00000001
> 18,ProcessorType,586,PROCESSOR_INTEL_PENTIUM
> 19,PhysicalMemory,511,511 (536264704)
> 20,Product ID,NULL,NULL
>
>
> --
> Kzeto Ng
>|||http://www.aspfaq.com/2160
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:ev9prZIuDHA.3220@.tk2msftngp13.phx.gbl...
> Hi,
> The below result i get from running xp_msver, but is this information
> showing any SQL service pack information?
> How can i get it?
>
> 1,ProductName,NULL,Microsoft SQL Server
> 2,ProductVersion,524288,8.00.760
> 3,Language,1033,English (United States)
> 4,Platform,NULL,NT INTEL X86
> 5,Comments,NULL,NT INTEL X86
> 6,CompanyName,NULL,Microsoft Corporation
> 7,FileDescription,NULL,SQL Server Windows NT
> 8,FileVersion,NULL,2000.080.0760.00
> 9,InternalName,NULL,SQLSERVR
> 10,LegalCopyright,NULL,© 1988-2003 Microsoft Corp. All rights reserved.
> 11,LegalTrademarks,NULL,Microsoft® is a registered trademark of Microsoft
> Corporation. Windows(TM) is a trademark of Microsoft Corporation
> 12,OriginalFilename,NULL,SQLSERVR.EXE
> 13,PrivateBuild,NULL,NULL
> 14,SpecialBuild,49807360,NULL
> 15,WindowsVersion,143851525,5.0 (2195)
> 16,ProcessorCount,1,1
> 17,ProcessorActiveMask,1,00000001
> 18,ProcessorType,586,PROCESSOR_INTEL_PENTIUM
> 19,PhysicalMemory,511,511 (536264704)
> 20,Product ID,NULL,NULL
>
>
> --
> Kzeto Ng
>

How to get rid of time in a date/time field?

I am using vb.net 2005 with crystal and I am wanting to only show the date on the record being grabbed from SQL. currently it is showing the date along with the time stamp. Is there an easy way to do this in Crystal?I figured it out...format object :-) Easy enough!