Justin Cooney
Web Development Tips and Examples
Category: Database
-
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…
-
Recently I was asked to update our homegrown timesheet application that had been written years ago in classic ASP. The update was simply to take a user name in the string format ‘Last Name, First Name’ and convert this to our company standard email format of FirstLetterofFirstName + LastName + @companyname.com Now it has been…
Justin Cooney 