Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Ways to Determine the Version and SP of SQL Server Expand / Collapse
Author
Message
Posted Wednesday, March 31, 2004 11:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 24, 2013 3:23 PM
Points: 108, Visits: 399
Great article.  I do have a question; how can I output the results from master..xp_msver production to a table?
Post #109330
Posted Thursday, April 01, 2004 12:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:49 PM
Points: 2,866, Visits: 1,708

CREATE TABLE #MyTable(<column name> <column Type> , etc)

INSERT #MyTable(<fields>
exec master.dbo.xp_msver

 



LinkedIn Profile
Newbie on www.simple-talk.com
Post #109423
Posted Friday, May 28, 2004 2:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 08, 2010 11:35 PM
Points: 71, Visits: 196

Thanks, Very useful to find the version and sp of sqlserver

 




Kindest Regards,

karthik

Post #118168
Posted Tuesday, October 18, 2005 5:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 04, 2013 8:00 AM
Points: 15, Visits: 130

Thanks, for the information provided. but it will be a great help if anyone could send a list of patches released and what patches are included in the service pack

 

Thanks In Advance

Gowtham

 

Post #229668
Posted Thursday, May 03, 2007 2:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 08, 2009 4:14 AM
Points: 1, Visits: 28
very informative
Post #362898
Posted Monday, May 14, 2007 6:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:42 AM
Points: 2, Visits: 65
Lovely and Brilliant short notes, Help alot....
Post #365580
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse