Justin Cooney
Web Development Tips and Examples
Category: SQL Server 2008
-
While rolling out a large stored procedure to our test servers today Luvy and I got a cryptic seeming server communications error message indicating there is a problem with the MSDTC settings. The transaction manager has disabled its support for remote/network transactions At first we thought this had something to do with the linked server…
-
First off let me start by saying that if possible it is best to avoid using cursors since they do have their drawbacks (for starters, they suffer performance issues). However in my opinion, there are times where cursors are very useful. There seems to be an ongoing witch hunt to vilify cursors that I do…
-
This week Luvy and I encountered an interesting issue with SQL Server. We were working on a project that we ported over to SQL Server 2008. As part of the work we were working on a scheduled stored procedure that selects into a temporary table and then does a fairly standard cross server bulk update. The…
Justin Cooney 