Sqlexception 判斷錯誤類型

use a try catch block like this: 

try
{
  ...
  ...
}
catch (SqlException ex)
{
  switch (ex.Number) 
    { 
        case 4060: // Invalid Database 
                  ....
                  break;
        case 18456: // Login Failed 
                  ....
                  break;
        case 547: // ForeignKey Violation 
                  ....
                  break;
        case 2627: // Unique Index/ Primary key Violation/ Constriant Violation 
                  ....
                  break;
        case 2601: // Unique Index/Constriant Violation 
                  ....
                  break;
        default: 
                  ....
                  break;    
       } 
}

如何強迫 .Net 應用程式輸出英文的例外訊息

System.Threading.Thread.CurrentThread.CurrentCulture = 
    new System.Globalization.CultureInfo("en-US");
System.Threading.Thread.CurrentThread.CurrentUICulture = 
    new System.Globalization.CultureInfo("en-US");

除了可以用在 Console Program 外，同樣的程式碼一樣也可以運用在 ASP.NET、Windows Form 或任何其他 .Net 應用程式中喔！

mssql 清除log檔

backup log 資料庫名稱 with truncate_only; 
dbcc shrinkdatabase(資料庫名稱);