How do we check to see what is the latest service pack applied to the sql server?
Jun 02 '10 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 '10 at 01:10 PM
Jun 02 '10 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 '10 at 12:53 PM
Seen: 696 times
Last Updated: Jun 02 '10 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
Rename a Table Column
Empty Stored Proc takes 8ms to complete?
HOW TO READ A TIMESTAMP IN A TABLE
please cancel my previous question about CROSS APPLY
Cannot get Maint plans working through MSX on SQL 2008
Creating Data Source Views with a Database Lacking Primary Keys
SQLDUMPER.EXE gone rogue