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 and exception in ASp.net 2

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-08-11 : 17:33:25
i am doing to write to event log information like :

RAISERROR(@sql,50000,16) WITH LOG

but this makes in my asp.net 2 application an exception with error
is there a way to avoid this?

thnaks i nadance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-12 : 03:28:15
You can't both write a custom message and have a custom error number.

RAISERROR(@sql, 16, 1) WITH LOG



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -