That was it! Sometimes it's the simple things that elude you 😀

There were 2 of us looking at it and we both missed that - and the other guy has...

Is there any way of setting it up so that user can leave off parameter entirely.

e.g. If I try SELECT * FROM myTbl it errors with 'Parameters were not supplied'...

Thanks Chris!

And you're right, I'll include samples in future 😉

I don't know why, but not only did I have to change the Order By Key, but also had to set the NameColumn and the ValueColumn in order to retain...

Yeah, that did it! - it had 90% fragmentaton and data pages were only 50% used. Rebuilding indexes brought it down to its original size.

But I'm still curious...

I have a similar situation where I added a single int column to a table that was ~ 60M rows and consuming ~10GB space. After adding the column and populating...

Very cool articles Grant - I think these will help me a lot develop a solution that will work for us.

Thanks a lot!

I see where using a version id vs Y/N indicator makes more sense, but am confused as to how the FK relationship would work. Let's say the region table also...

Jeff - so using datetime or smalldatetime with between will not work as well as >= and <= but will not matter if another type like int or char? Is...

Stupid me - ypu're absolutely right!

value1 >= value2 AND value1 <= value3

was quicker by a few seconds than

value1 BETWEEN value2 AND value3

I know, not my understanding either and why I...

the 2 links refer to different versions - 2000 vs. 2005. But it does raise a question in my mind: what's the largest file size anyone in the community has...

I got it to work by removing the Express versions and installing the eval. version. Now I can see the Legacy DTS app - and everything still works on SQL...

Ok, I've tried it 2x now. No success. I removed all versions of SQLServer, the folders that were left behind for SLQ2K, reinstalled SQL2K, reinstalled SQLserver 2005 Express, then reinstalled...

I un-installed SQLServer Management Studio Express, re-installed SQL2K client tools, then installed Management STudio Express. BUt still don't see any legacy app. for DTS designer.

What am I doing wrong?

Problem is, I don't see a Legacy folder.

As regards Express vs. Standard, I agree. Not sure why we don't have. I've asked, but still no reply.

The frustrations of working in...