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: 642 times
Last Updated: Jun 02 '10 at 12:53 PM
Issue installing MS Sql 2008 sp3
MS SQL SERVER 2008 Service Pack 3 for Production
Upgrade MS SQL 2008 RTM to SP3
difference between sql server 2008 r2 standard edition and enterprise edition
Low Physical Memory Warning Message From Red Gate
Microsoft SQL Server 2008 Service Pack 2
Please let me know error in following code
Connection pointer getting closed automatically
A question for SQL Azure Beta Users