Home » Technology (Page 3)
Category Archives: Technology
Cumulative Update – 3 for SQL Server 2012 Service Pack 1 Is Now Available !
The 3rdcumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 3 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 CU3 in test environment & then move to Production after … Continue reading
SQL Server 2000 Extended Support ending soon………21 days left
· On April 9, 2013, Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will no longer be supported. · What will change : · Self-Help Online Support will be available for a minimum of 12 months. Example: Microsoft online Knowledge Base articles, FAQs, troubleshooting tools, and other resources, … Continue reading
DMV-1 : Who All Are connected ? …. sys.dm_exec_connections
The sys.dm_exec_connections DMV (Dynamic Management View) is represented by Books Online (BOL) as follows : http://msdn.microsoft.com/en-us/library/ms181509.aspx Returns information about the connections established to this instance of SQL Server and the details of each connection. sys.dm_exec_connections is the most common DMV used to get connection details. We will get details info regarding every connection like protocol … Continue reading
SQL Server Discovery Report
How can I check what all SQL server features and version are installed on my Machine ? It’s a frequently asked question. You need to study your environment, need to login each instance to check version & other details, to answer this question. Till SQL Server 2005, you have no direct solution. But Starting from … Continue reading
Backup not starting for Database with Full Text Catalog…………..Failed to change the status to RESUME for full-text catalog in database. Error: 0x80043607
Issue :- One of our Database with Full Text Catalog is not getting backed up. When I checked, backup keeps pending on 0% without any progress. In SQL server error log, I also found error related to Full text catalog that SQL server is facing issue in setting Full test catalog status. These is some … Continue reading