I need to do some validation inside a stored procedure before I continue processing but SQL Server PDW (SQL Server 2008 R2) does not support RAISEERROR inside stored procedures.
Is there any other way that I can raise an error with a specific error message inside a stored procedure?
I can try and do something illegal, like force a "division by zero" error, but the error would be misleading.
I'd like to be able to raise an error specifying the exact problem that's occurring.
Any other way?