Skip to content

Obscure Problems and Gotchas

If you couldn't find your answer to your weird problem, you might find it here.

  • About
  • Application Errors Hall of Shame
  • DyslexicApps
Development, SQL Server

RedGate SQL Compare – Index was out of range error

by: admin2018-12-01

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

SQL Server

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

by: admin2016-12-25

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

Uncategorized

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

by: admin2014-03-12

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

Uncategorized

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

by: admin2012-08-07

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

Uncategorized

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

by: admin2012-01-18

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

Search posts

Happy find? Help me buy the coffee that fuels these articles!

Like what you are reading?

It takes time to write these quality blog posts and sometimes software. Maybe something I have written has benefited you? Blog posts can take anywhere from a few minutes, to a couple of hours, to several days to construct. Software is a constant work in progress. Want to help me buy my next bag of coffee?

Anything is appreciated

Categories

Recent Comments

  • Paloma on DataGridView Loses Formatting and Columns After Setting DataSource a Second Time
  • Caleb on MVC CSHTML partial view loses all syntax highlighting/color during rename operation; then copy, cut or paste operations cause Visual Studio errors to be thrown
  • Rilwan on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • admin on Biases in naming database objects
  • Alberto D. Sarubbi on Biases in naming database objects

Archives

Search posts

Search posts

SSL Secure

Copyright © All rights reserved. Theme Creativ Mag by Creativ Themes