Most unhelpful error message?
-
Anyone else have a story about unhelpful error messages?
Got an error message "an invalid directory pathname was passed" during SQL Server 2014 install, when specifying the service accounts.
The cause was entering the account with a forward slash instead of a backslash. Usually I do these from home on my 23" monitor but this was done at a client with a 12" laptop screen, so did not notice the difference.
Domain/account produced a invalid directory message.
Domain\account is the correct format.
SQL = Scarcely Qualifies as a Language
-
At least you didn't get this.
The absence of evidence is not evidence of absence.
Martin ReesYou can lead a horse to water, but a pencil must be lead.
Stan Laurel -
Used to use a marketing suite with some very unhelpful error messages. It used NSQL IIRC, and many of the errors were along the lines of "Error: No error".
I do not miss it.
-
I would occasionally get an error with a SQL 7 box that would just have the Ok button and no message.
-
There's one out there that I've seen since SQL Server 6.5. It reads something like:
The query failed to process for the following reason(s):
The operation completed successfully
The one that drives me the most nuts though is
String or binary data would be truncated
SQL knows which column it is but doesn't want to share this info with you. That one drives me the most nuts, especially when it's a really wide table with many columns.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply