Where you said check and "don't clear the related SQL tables".

Another approach you might find useful as well is load from the AS400 into a temp table, then do your...

Right. But have you seen anything that said SQL Server could USE the 32G (or a substantial part of it) on W2003EE?

I've never had any luck saving as structured files, the search tends to not find what I'm looking for, I think (emphasis on think) because many things are stored as...

Are you sure that the statistics on the two are the same? Also number of processors and the options set? Exactly same service packs and such?

I wasn't aware...

If you are going to host the SQL Server database, then you need some version of SQL Server suitable. If you have MSDN Universal you have rights to all...

The timing of this is fascinating. I worked out a solution using functions late last week and learned a lot more than I really wanted to know.

In my case...

That may well be it (that it is a table function). That's one of the few places we have them, and this was the only one that I have...

Sample, sure. Here it is. I run the first 4 statements separately, then the rest are what I'm timing. I've attached the statistics run below. The query...

No, SQL Server is at 1.7G, and other things appear to be using the rest of the memory (whether efficiently or not I do not know, there seems to be...

Well, I knew about that table. I also new Windows standard could support 4G. I figured this mean that SQL Server standard could use 2G of the (up...

But isn't Windows 2K standard support to be able to support 4G?

And SQL Server 2K Standard 2G?

I mean -- did I do something dumb and miss a spec? Is...

I just did a quick search and our source safe contains an even 200 DTS packages. Fortunately I have only two databases to deploy these two.

However, I found just...

We use Microsoft Source Safe and have had no issues in that rergard.

I looked at the meta data stuff briefly, and am embarassed (or Microsoft should be!) that I have...

I required our group, from the beginning, to not store them in the database. That's very contrary to what most people do, but from my perspective it made them...