SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Andy Warren
Author:

Author Bio:
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
Using @@Version and xp_MSVer to Get Your SQL Version

Using @@Version and xp_MSVer to Get Your SQL Version

Are you on the latest and greatest service pack? Not even sure what version of SQL Server you're running? Running a simple query using @@Versionor xp_msver will give you all the information you need!

Video Information
Publish Date:
February 01, 2010
Length:
1:34
Skill Level:
100
Rating:
4.33 out of 5

After watching you should be able to answer these questions:
  1. Which of the following will tell you how many processors are available on the server?
You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Stéphane Thinel on 2/1/2010
Make the fonts bigger in your query window and everything will be perfect

Craig on 2/1/2010
I like the quiz a LOT. Keep those coming.

Syed Hassan on 2/1/2010
Thanks for Sharing this. This is great for beginners like me

Mike Salo on 2/1/2010
Good tip.

Mike on 2/1/2010
i like these short and sweet ones every once in a while

Serghei on 2/2/2010
that's fine

Serghei on 2/2/2010
that's fine

Guy on 2/2/2010
Great Video !!

Lloyd Edwards on 2/2/2010
none

Pat on 2/2/2010
video shows xp_server will give more details including # of processors. In quiz to test whether we're paying attention, xp_msver is the correct answer. Is the video not correct then?

Diana Dee on 2/8/2010
At first I thought your result pane covered up the xp_msver query and we would not get to see it. But you eventually went back to the query pane. Thanks!



Must Be Logged In

References
Version Script

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions