Category: SQL Server

SQL: REPLACE Multiple Spaces with One

I have just found a very useful article from SQLServerCentral.com, that goes through the process of replacing multiple spaces with one. “Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here’s a set based method for replacing multiple spaces from MVP Jeff Moden” http://www.sqlservercentral.com/articles/T-SQL/68378/

SQL: SSIS Error When Sending Mail Through SMTP

Today, I came across this error, that occurred when running an existing SSIS package: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: “Syntax error in parameters or arguments. The server response was: 5.5.4 Invalid Address” After lengthy investigation, I discovered that one of the email addresses […]

SQL: Cannot Connect To SQL Server Analysis Services 2008

Whenever I tried to connect to Analysis Services using the SQL Server Management Studio 2008, I was getting the following error: Cannot connect to [Computer Name]\[Instance Name]. A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient) No connection could be made because the target machine actively refused it ::1:54226 (System) I trawled […]