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.

August 1, 2004 at 9:52 pm

#517164

Sounds like the DBA instituted a maintenance plan and is doing other things than just the backup, as previously offered by SQLBill If this is the case, that DBA has...

Are there any trust relationships established between the domains? If so, in what direction?

Is the use of SQL Server logins an option?

Do not use the auto-repair option for the reason you've seen (single user mode issue). If a database throws an inconsistency error with a DBCC check, you'll probably want to...

No. just by knowing the sa password you can't directly get the password for the administrator account. You'd need to brute force the password using some sort of tool. However,...