shettyprashant

Looks like I spoke too early. The alert is still broken. When I do a Test Alert it works fine & shows the statement & hash. But the actual mail is not coming. Not sure where the it is broken. Error shown is same "expected number". Prashant

Thanks for the tip. Its working now after I removed the PName column. Though it would be nice to have this as well as maybe include the Login name. Prashant

Yes... same error. "Alert returned the value [ -- ============================================= -- Author: -- Create date: <08-03-2013> -- Description: -- ============================================= CREATE FUNCTION [dbo. =====which is not of the expected type [Number]" Am getting H, ST, PNAME from const_#DBID# in the…

Hi, I tried using custom alert but the return types are numerical, boolean or alert status. There is no option to return a text (in this case the query statement). So is there any other way to get this besides manually running the query. Prashant