Sample Header Ad - 728x90

Behavior of case sensitivity of RAISERROR when run remotely

2 votes
1 answer
493 views
I have a remote SQL Server that I can connect to using a local instance of SSMS. When raising errors, we use RAISERROR( 'This works', 16, -1 ) Remotely, this works fine if it's all uppercase, or even if any one letter is uppercase. raiserRor( 'Still works', 16, -1 ) If I try to run it using all lowercase though, it does not work raiserror( 'Error', 16, -1 ) It returns the error message >Msg 121, Level 20, State 0, Line 3 >A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) Even if I comment out the lowercase raiserror statement it still fails with the same error message. If I log on to the server and execute these statements, they all work. It only seems to be when I connect remotely that this is an issue. Why can't RAISERROR be completely lowercase? Even if commented? --- The server is an install of SQL Server 2012 Developer edition on Windows Server 2012. >Microsoft SQL Server 2012 - 11.0.5058.0 (X64) > May 14 2014 18:34:29 > Copyright (c) Microsoft Corporation > Developer Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor) I've used local installs of SQL Server Management Studio 2012 and 2014 and tested against databases with 2005 and 2012 compatibility levels and the same behavior occurs. I tested on other machines and the same results occurred. I don't currently have a machine to test outside of our companies network though.
Asked by Brandon (151 rep)
Feb 12, 2016, 05:50 PM
Last activity: Feb 12, 2016, 10:16 PM