SQL Server Error Message : SQL Server Error Msg 421, Level 16, State 1: The ntext data type cannot be selected as DISTINCT because it is not comparable. Cause : The text, ntext and image…
Read More
SQL Server Error Message : Msg 468, Level 16, State 9, Procedure sp_Sales_Invoice, Line 209 Cannot resolve the collation conflict between “SQL_Latin1_General_CP850_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. How to resolve : SELECT…
Below is DBCC SHRINKFILE statement to shrink the transaction log file manually : For SQL Server 2005 : USE [DatabaseName] GO DBCC SHRINKFILE([DatabaseName_log], 1) BACKUP LOG [DatabaseName] WITH TRUNCATE_ONLY DBCC SHRINKFILE([DatabaseName_log], 1) GO For SQL…
March 6, 2012 Microsoft announced the latest version of Microsoft SQL Server 2012. The product will be available on April 1. You can download for evaluation version at http://www.microsoft.com/download/en/details.aspx?id=29066