Posts

Showing posts with the label compatibility

SQL Server: Basics on Upgrade edition and Apply service pack

Apply Service Pack to SQL Server: First determine what is going on your server SELECT             SERVERPROPERTY ( 'ProductVersion' ) AS ProductVersion ,             SERVERPROPERTY ( 'ProductLevel' ) AS ProductLevel ,             SERVERPROPERTY ( 'Edition' ) AS Edition ,             SERVERPROPERTY ( 'ResourceLastUpdateDateTime' ) AS 'ResourceLastUpdateDateTime' ,             SERVERPROPERTY ( 'ResourceVersion' ) AS 'ResourceVersion' GO Follow this link to continue upgrade. SQL Server Edition Upgrade: This link has an overview of how to upgrade your existing edition. Compatibility Check: You can chec...