That gateway supports email, so sp_sendmail should work.

Don't do this from a trigger. Let the trigger drop data in a table and then use a job that checks the table...

I tend to agree with Paul. Adding columns to support different characteristics might be breaking a normal form and repeating data for no reason. It is also harder to search...

There's a default trace as well. Search that, it might have the info you need if you check it soon after the event.

We don't know what your XML looks like or the table. We don't know the data, and you didn't give the error.

Please provide more details.

Moved to XML forum

You pay a price with encryption. Are you sure that you need to encrypt dates?

Good points, Paul.

I like the idea of using a view to join the tables together if you need that.

Are you querying by month that often? I'm just wondering if...

You can create an indexed view, but it cannot contain a derived table (http://technet.microsoft.com/en-us/library/cc917715.aspx).

I'm not sure how you could create an indexed view here. You might want to create a...

And read Managing Transaction Logs[/url] by Gail

It was an error writing to disk. Is this a local drive? Any issue writing to disk usually causes the backup process to fail; it's why backups to non-local disks...

ITDPNDS

I'd compare prices on books for sure, as suggested, to see what the savings are.

The hassles of sharing, might not be worth it, but it is handy to be able...

The connection, or maybe there isn't one, is that what type of rights does an individual deserve with their purchases. If you purchased a book from Amazon, and they can...

clean, used books? give me a battered, dirty, bent copy any day, as long as all the pages are in there!

E-books are OK. reading on an LCD (pc, iPhone,...

Video: http://www.youtube.com/watch?v=uJm-N-jksvE&feature=autoshare_twitter

It might be rights, though I'd expect a security error. Are the rights of the agents changed?