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: 771 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
SQL 2008 Compression
migrating from sql server 2005 to sql server 2008
How to consolidate multiple similar SSIS packages that export data to txt file
How to attach a debugger to the server process and retrieve the decrypted procedure from memory at runtime?
Combining two rows in one record
Dynamic SQL questions
saving jobs output to a text file