What version am I running?

[Jonoman1]

I am a novice w/SQL, and will probably end up that way forever, sadly. I've got a machine that looks like it is infected w/SLAMMER. I've downloaded the patches from Microsoft, but I've been stalled: I cannot continue w/ update & fix until I address what version I am running (2000, sp1, sp2 etc) I'm guessing 2000 (on a 2000 pro OS.)
Where can I find my version? Thanks.

 

[SpiderBear6]

Do you have the little server icon in your system tray? If you do, you can right click and select About. Version 8 is 2000.

 

[clarkin]

or run in QA:

SELECT @@VERSION

or

EXEC xp_msver

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].

 

[JamesLean]

After running

SELECT @@VERSION

, compare your version number to the list at the link below to determine the exact version and service pack level:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

--James