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 […]
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, […]
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 […]
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 […]
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 […]