SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Idera Virtual Database

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!

Duration:
1 mins 34 secs
Skill Level:
100
Rating:
4.37 out of 5
Publish Date:
February 01, 2010
Using @@Version and xp_MSVer to Get Your SQL Version Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
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.

References



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!

soykan ozcelik on 3/16/2010
good



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

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