Justin Cooney
Web Development Tips and Examples
Category: SQL Server 2008
-
Crystal Reports XI R2 and Crystal Reports 9 incorrectly generate non-critical connection error logs when set to run reports from SQL Server 2008. Specifically, when Crystal Reports is connected to a SQL Server 2008 database it will serve the report correctly, but invisibly it will also generate an error log in SQL Server. Although insignificant…
-
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…
Justin Cooney 