Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Dinesh Priyankara Ways to Determine the Version and SP of SQL Server RE: Ways to Determine the Version and SP of SQL Server
David.Poole
SSC Guru
Points: 75896
More actions
April 1, 2004 at 12:57 am
#501409
CREATE TABLE #MyTable(<column name> <column Type> , etc)
INSERT #MyTable(<fields>
exec master.dbo.xp_msver