If you are receiving the following error related to connection to SQL Server, this blog is for you.
SQL SERVER – FIX – ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. If you receive above error it means you are in great trouble. This error occurs when database is attempted…
Read MoreSQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.
If you face following error the solution of this is very simple. Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process. Above error comes up with Service Broker. Service Broker is used to send Database Emails. Read more about SQL…
Read MoreSQL SERVER – Deferred Name Resolution
One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is incorrect table name in the SP it creates the SP fine but while executing it gives run time error. However, if there is any valid table from database is referenced in SP…
Read MoreSQL SERVER – Create Check Constraint on Column
I found one of the Jr. Developer writing trigger for the requirement where he wanted to make sure invalidate data does not enter in table column. I suggested him to write Check Constraint. Check Constraints are very handy to make sure all the data in the table is validated before…
Read MoreSQL SERVER – Orphaned MS DTC Transaction Information
Few days ago, one of our application was crashing IIS application pool because of unhandled exception. After researched we figured out the case of it was orphaned MS DTC transaction. When multiple connections are operating over one MS DTC transaction, this problem sometime shows up. As many connection are working…
Read MoreSQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server
Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server. He has found solution and would like to share with SQLAuthority Blog Readers. Hi Pinal, Recently,…
Read More