If you've installed sP2 and have the reports, the "Schema Changes History" is a visual version of that function as well.

http://www.microsoft.com/sql/howtobuy/faq.mspx

From the "how to license SQL Server" FAQ:

Q. What exactly is a processor license and how does it work?

A. A processor license gives you the right to install any...

In 2005, xp_sendmail should be avoided. It's been replaced by sp_sendDBMail, which tends to operate much better (it's SMTP-based, so doesn't required an outlook client to be installed and...

Yup - Vladan's right. Missed a few moving parts there.

thanks for the assist!:D

The correlated sub-query can suffer depending on how big the table is. You might care to try a derived table setup:

SELECT a.[Invoice no], a.[invoice Amount], (a.[invoice Amount] - isnull(b_sum.TotPayment,0))

FROM...

Glad that did the trick! thanks for the feedback

On the other hand - you're apparently trying to put a character value into a column that is an integer type, so that will NEVER happen. Avoiding that would allow...

As it is - that's a batch-terminating error. Meaning - it pretty much drops out right then and there and never goes past it.

In 2000, the only way I...

It looks to be ASCII code 168. Run your REPLACE code with CHAR(168) as what you're looking for.

As in - (using a square bracket as the replacement)

select replace('YAHOO¨ TRAVEL',char(168),']')

Jeff Moden (10/3/2008)

---

Actually, I was talking about SQL Server 2000 'cause I'm still stuck in that world for better or worse. I forgot this was a 2k5 forum.

I just...

How do the rows in table2 match up to rows in table3, match up to rows in table4?

You need some type of join between the 3 tables, but you're not...

If you're going to schedule it - perhaps just let the job scheduler send the e-mail. Xp_sendMail can get really funky, since it won't release until the e-mail is...

A web service you pass parameters to, which then builds the query or executes the query on the remote end is a viable option. or - a CLR asembly....

This is a "running count". A high-speed version of what you'd need to do is described in Jeff's article below:

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/%5B/url%5D

Like you've already mentioned - it's not a set-based solution...