Category Archives: SQL Server

The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 1 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are facing severe issues with their environment, they can plan to test CU1 in … Continue reading →

Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels (MSDN…) and are now available. Refer : http://support.microsoft.com/kb/2984316 Source : http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/18/sql-server-2012-with-sp2-slipstream-iso-images-fixed.aspx If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun Reference : Rohit Garg (http://mssqlfun.com/)

The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 11 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are facing severe issues with their environment, they can plan to test CU11 in … Continue reading →

Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of Service pack setup. Informatory details only. Step 2 : Confirm EULA (End User License Agreement) to move ahead. Step 3 : Select instance & features you want to patch or upgrade. Note : … Continue reading →

You need to run the following query and it will give you the date of your SQL Server Installation. SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’ FROM SYS.SERVER_PRINCIPALS WHERE SID = 0X010100000000000512000000 SID 0X010100000000000512000000 is belongs to user "NT AUTHORITYSYSTEM". This user create at the time of installation only. If you liked this post, do like on … Continue reading →