How do we check to see what is the latest service pack applied to the sql server?
Jun 02, 2010 at 12:53 PM
You can run with SSMS
And then compare to the build list on SSC...
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Jun 02, 2010 at 01:10 PM
Jun 02, 2010 at 01:18 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jun 02, 2010 at 12:53 PM
Seen: 833 times
Last Updated: Jun 02, 2010 at 12:53 PM
MS SQL SERVER 2008 Service Pack 3 for Production
Upgrade MS SQL 2008 RTM to SP3
Issue installing MS Sql 2008 sp3
Comparing two records from two rows and do something IF > 3
Operand data type varchar is invalid for subtract operator.
sql server 2008 R2?
Find all sub-2 Childs of a Parent
what counters we should monitor on the principal & mirror
Different behavior of SQL 2008 SSMS while accessing Linked server database.