It sounds like you are looking for three pieces of information. given the amount of people that have looked and the lack of anybody responding I will take a stab...

I think you may need to brush a bit on the concept of views also. You do not put a trigger on a view nor does anything update a view....

Assuming Date_Stamp is a datetime datatype you should make the variables datetime and not varchar otherwise you are forcing sql to do an implicit conversion over and over. If you...

and numeric 6??? Are you trying to store mmddyy instead of the actual datetime?

Well in all fairness, Navision is probably a better system than what...

Ninja's_RGR'us (12/21/2010)

---

Sean Lange (12/20/2010)

---

Ugh! Navision aka No Vision. Just went through a lengthy migration away from that product for one of our companies. Interesting that their licensing is based on...

Who is the owner in this case and does that account have permission to execute sp_send_dbmail?

For the trigger itself, It looks syntactically correct but I am not sure the logic...

http://msdn.microsoft.com/en-us/library/ms182717.aspx

Ugh! Navision aka No Vision. Just went through a lengthy migration away from that product for one of our companies. Interesting that their licensing is based on the number of...

Why are trying to kill off these sessions? This sounds like you are having problems with the connection pool?

True that it is dialect. Guess what? This site is about sql server and it's dialect. It is not called sql programming for ISO compliant dba. 😛

Yeah i too was guessing he was forcing time to 00, I was really just suggesting doing the conversion once rather than over and over. 😉

Why don't you use datetime variables instead of varchar and convert them over and over and over and over???

MMD.[DateTime]>= convert(datetime, @strStartTime , 101) and

MMD.[DateTime]<= convert(datetime, @strEndTime , 101)

Additionally you...

Can you just remove the where clause to get all rows???

To look at your error:

Your subquery does not have an alias. You also should not use select *

lol Gail, you beat me to it. 😛