AndreRet,
I was searching an ADODB function that let me to interrogate server because I want konw if it is up or down. At the moment I find a workaround...but I don't like it. Do you know if there's...

Yes, AndreRet! you understand exactly my problem.
IF myconnectiontoSQL = TRUE then
Could you explain better your code? Because I try to implement your code but I got an error on this line. (Type...

I want to detect when connectivity with SQL Server fails, so i can fire an alert for the user.

Does anyone know a bit of code that will help me detect when connectivity with the SQL Server fails...

The problem is only with trigger! if I made a query everything work fine. The trigger fire, I'm sure!

Why not? :confused: In MSDN there's this explanation of RAISERROR:



By the way, I've try also to generate an error typing...

This is an error! but code in CATCH are not execute. :-/
any...

Hy, you guys!
I'm trying to implement in a trigger write by-me error handling with TRY...CATCH, but I'm loosing a lot of time without success. :'(
Here there's a simple code write for test:
ALTER...