RedGate SQL Compare – Index was out of range error

Problem This was a weird one because it is clearly a bug in the software. I am running version 13.6.1.7928 Professional of RedGate SQL Compare and I kept getting this error after performing an upgrade...

How to find the current profile required to send an email in SQL Server

Problem You are trying to send an email using “msdb..sp_send_dbmail” but you keep getting one of the following errors: Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107 [Bat...

File Name, File Path or Full File Path name is too long

The Error The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters. The Problem I ha...

How to get Filename and File Extension from a Column with tSQL

I have written this query like 100 times, but this time I am going to document it so I don’t lose it again. This query specifically assumes that you have a single column that contains a file nam...

SQL Server: Attaching a Second Copy of a Database that Exists Already in the Same Server

This was a fun one, I couldn’t find a definitive answer on this so here is mine. Question How can I attach a database (MDF/LDF) to my server that has the exact same name as one of the ...