RAISERROR - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

RAISERROR

Author

Topic

kurtgr
Starting Member

25 Posts

Posted - 2009-07-10 : 13:24:17

Hi ALL

I seek your assistance.

When using RAISERROR i get the following error

Connectivity Error:[Microsoft][ODBC SQL Server Driver][Sql Server]Deletion Failed

I only want to display the message section
Deletion Failed

What the syntax to substring this RAISERROR to eliminate
Connectivity Error:[Microsoft][ODBC SQL Server Driver][Sql Server]

Section

Thanks In Advance for your help

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-10 : 13:26:03

It's not the RAISERROR that prints the "Connectivity Error:[Microsoft][ODBC SQL Server Driver][Sql Server]". It's your ODBC driver...

N 56°04'39.26"
E 12°55'05.63"

kurtgr
Starting Member

25 Posts

Posted - 2009-07-10 : 13:29:54

Thanks for your responds but how can i eliminate this from coming up

I want to return this message from a trigger without that section

Thanks again in advance

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-10 : 13:37:41

You can handle the error from your application and not by using a generic error handler.
I don't know about ODBC, but OLEDB and ADO has the ERROR collection where the specific error message is stored.

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources