I have them all.

Great. How'd you fix issue 2?

Hey Lynn, how's the new job going?

bitbucket-25253 (3/8/2012)

Evil Kraig F (3/8/2012)

I want two... I know...

Yup that works and I considered the conversion to INT as well, but that means you are assuming that the vehicleid is always the same with a a 0 or...

I believe issue 1 can be fixed by adding the report server to trusted sites in IE.

I don't know what's happening with issue 2. Can you post the...

Thanks guys. I got mine about 2 minutes AFTER I posted about it here. Usually it is waiting in my inbox when I wake up, so I have...

If you have AV on the server, check to make sure the DataBaseMail.exe is not being blocked. McAfee blocks it by default in the mass mailing rule and it...

Something like this should work for you:

DECLARE @tableA TABLE

(

vehicleID VARCHAR(5),

[timestamp] DATETIME,

...

Test email worked?

Are there any errors in the database mail log?

Has anyone gotten the newsletter today? I have not and I keep getting a notification email for the same post.

Not to be downer on rolling your own solution, you also need to take into account the time to develop, refine, and support the solution you create, which often times...

I don't think that there is a way to do this. I think you'd be better off going with a file configuration and deploying the file with the package...

Never heard of such a thing happening.

How long does the delete take?

What are the indexes?

What is the locks taken by the delete?

The Trigger fires AFTER any insert or update to table XYZ. The trigger code executes in order it is written in. So your example the order would be:

1....