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: 703 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
Incorrect Syntax on Declared VarChar
What is the best approach to utilize database compression functionality of MS SQL 2008(Enterprise Edition) in respect of OLTP and OLAP databases?
remove unwanted characters from column
SQL Seelect Query taking more Logical reads please suggest best optimization technique
Adjusting GetDate() in agent job.
SQL Agent Jobs Backup
Error:**ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.**