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...

Ann,

That's the idea, except that you have to switch the app users to the secondary server. Either they connect to a new name, or you rename the server. The...

Outback,

Thanks for the reference, that's good information.

Rudy,

Do you know how fragmented things are when 1.4 has worked? Slightly? Severely? I've seen this questions before and it would be...

Phillip,

Apologies for that and I'm not sure what it is either. I know since I've switched to FireFox it doesn't happen to me, but I suspect there'e something in the...

The reference basically is for how a child process may relate to a parent process. If you wish to spawn another process, but it runs within the memory space and...

Ha,

select 1 'rank', 'Steve', max(bigint)

union

select 2 'rank', user, count(posts)

from forum

group by posts

How's that?

Please post these questions in the appropriate forum. This one is for the Question of the Day.

Please post this in the appropriate forum. this is for the Question of the Day.

I investigated Object databases a few years back and they were interesting. I think NASDAQ or the Chicago Commodity board had used one with great success. The idea seems to...