Where are the suck-ups? No votes for Andy, Brian or myself . We have shirts and books to give away

You can create a linked server which will allow you to query a table on server B from server A. The syntax is in books online and there. There are...

As an update, I have moved this to administration (SQL Server 2k)

Beware of the times, which are also included. You might want to add one day to the end day if you are missing values.

One of your fields is an identity field. Typcially you leave that field out of the insert () list and do not insert a value for it in the VALUEs...

That's less fun. Besides, I think I learned a few things by reading all the posts

I ended up changing the alias name so...

How do you tell that you have later dates? Is it just by the date? Is there some other linkage? If it's just by date, then how would you ever...

I like using something to differentiate variables from other code, especially non SQL languages.

for iCounter = 1 to 10

instead of

for counter = 1 to...

I think that things make more sense if we differentiate case sensitivity and programming is aided by using mixed case. But most humans don't work in mixed case well....

You can pass paraameters to a DTS package. There is also a looping example here: http://www.sqldts.com/default.aspx?246 that might work for you.

David,

That's really weird. AKAIK, BULK INSERT is a wrapper for the same code as bcp, but apparently that doesn't seem to be the case. All the servers have SP4? Are...

Have you checked that the SMTP server is receiving the message? It looks like it should work, but honestly, I've had issues with CDO/CDONTS. I used ASPEmail from my SQL...

I think the function might necessiate a materialization of the data in tempdb, such as an order by or a group by does.

That is strange. When you say they are spaced by 5 minutes, do you mean that the times between all emails are 5 minutes, as in one is sent and...

I tend to agree, though if you have some auditing requirement about the information that's stored there (job history, backups, package changes, etc), then you might want to move to...