Hi all, I figured out what the problem is and now the alert is firing just fine.

Thanks

Gary

Thanks but no go.

Cannot use it in the select statement. I need it in the compute clause.

Thanks

Mr. Corey, I am not in the habit of lying, as you comments imply, and I am highly insulted by your remarks. If you want me to provide feedback...

I also downloaded LOG PI in expectations of being able to search a transaction log for a dropped table, or altered table. I had a very difficult time installing...

I was wondering about this situation. My production sql servers reside in a remote location, remote from our office, and hence they are in their own domain. We have production...

srgangu, as the other post mentioned, backup frequency is a product of your willingness to lose data.

If you have a very active system then you need to determine...

Just one other remark: when in query analyzer if you want the result to switch from text to grid press the ctrl key and the letter d, if you want...

hoo-t, first off thank you. 

In the script you provided you call sp_af_helprotect and apparently, by the results I got, you have modified the sp_helprotect that comes with sql. If I...

Just a note on this: if the object is renamed to a user other than the DBO, there is the real posibility that the object will fail. In the case...

Good topic.

I have been involved with MSSQL since 1994. During this time I got my MCSE and MCT certs. Not one time did these...

Mike, the people that have responded have offered some very good advice. If I were to repeat their words here it would be redundant, and since redundant data is not...