Justin Cooney
Web Development Tips and Examples
Category: SQL
-
In most places hosting instances of SQL Server, you will likely find older and newer versions of SQL Server running side-by side. This can of course become a challenge when you are writing code to make the servers communicate with each other. When writing a SQL query on one server, how can one tie together…
-
User defined functions are a useful tool when working with SQL Server. However recently as Luvy and I were working on creating a stored procedure we found out that user defined functions cannot be executed across a linked server in the usual way. We ran our tests on SQL Server 2008, but I believe this issue…
-
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…
Justin Cooney 