There is blat, was this what you were using? The advantage of xpsmtp is you can make a call from within a T-SQL batch without resorting to xp_cmdshell. So it...

Agreed. It is probably better here to load the data to a table from the trigger and then have an automated process pull the information asynchronous from the user.

XPSMTP

Use the on step failure/success options to direct to do different paths on the jobs steps. In case of failure fire off an SMTP email.

If the job is owned by a member of the sysadmin role, make sure the SQL Server Agent service account has rights. if the job is owned by an account...

It may fix the issue with virtual instances, but the notes from the article are for instances that aren't in the cluster. We were getting a dispenser interface error, not...

You only need SE for the branches. EE is required at the head office if you're going with a cluster. Keep in mind the cluster also require Windows 2000 Advanced...

An admin could set up a gateway server for Novell on a Windows server. That's one method.

When you are running the DTS package, are you doing so through Enterprise...

The consultant wasn't touching indexes, per chance? There is a known issue with putting indexes on computed columns. Greg has the right solution. Microsoft describes this behavior as "by design"...

Any advice, no matter who it is from, always take with a grain of salt. Still, these guys

are MVPs for a reason. They have shown a high level of...

With a bit of work, you can also set up a linked server connection to a text file instead of resorting to xp_cmdshell. An example is given of how to...

Andrew,

this is an error in Books Online. Users must be a member of the sysadmin role under SQL Server 2000 in order to execute traces.

K. Brian Kelley
@kbriankelley