Home » CodeProject (Page 6)
Category Archives: CodeProject
Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP2. Those who are facing severe issues with their environment, they can plan to test … Continue reading
Cumulative Update – 1 for SQL Server 2014 RTM Rollback by Microsoft !
The 1st cumulative update release for SQL Server 2014 RTM was released by Microsoft. But due to issues in setup Microsoft Rollback the release of CU1 of SQL Server 2014 RTM. KB Article For CU1 of SQL Server 2014 RTM CU#1 KB Article: http://support.microsoft.com/kb/2931693 Image Source : http://blogs.msdn.com/ If you liked this post, do like … Continue reading
How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ? 1) Open SQL Server Installation Center > Click Installation from Left > Click Add node to a SQL Server Failover Cluster from right 2) Click Run to start setup 3) Click Ok to cont., In case of any … Continue reading
How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?
Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :- 1) Open SQL Server Installation Center > Go to Installation from Left > Click on New SQL Server Failover installation from right 2) Click RUN to start setup 3) Click ok after validation check. In case of any failure, you need to … Continue reading
SQL Server 2000 || Disable sa login
Question : How to disable sa user in SQL Server 2000? Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances in environment having SQL 2000 \2005\2008 & 2008 R2. Answer : We can disable sa user from SQL Server 2005 onwards but this is not possible … Continue reading