I agree with Greg. Try to avoid dynamic sql.

you can switch compatibility mode back and forth. It doesn't change the structures or data, it just changes how things are interpreted.

On an import, I'm not sure. You'd have to know the sheet, or write ActiveX to connect to the Excel and read the list of tables. You might check here:...

I'll try to remember to post an announcement the week after.

Wow, I go to bed and the thread goes wild 🙂

SSIS is used to move data from many servers, fairly often, in the new Data collector in 2008, so it...

I don't think the furniture arrangement offers up a lot, but it does add something.

There was a lot of thought given to making things look good, more than a few...

Or SQL Server Steve?

Not sure either. Worse case I'll bug Lynn next week when I'm in the SPrings.

Moved to 2000 forum. Was too tired to do it last night 🙁

Wait until this Friday! I wonder what strangeness we'll get on the 13th!

I think you're right GSquared, not allowing the tools that come with the product is a little silly.

You can rerun setup and select "client tools".

Please use "I", "you", "your", etc, and not abbreviate "u", "i', etc. I might be old fashioned, but it is hard to read...

yes, isql/osql were the predecessors of sqlcmd.

You can use Query Analyzer as well, but you can't use the right side object browser since that requires it's own connection.

You can have parallelism, so potentially multiple threads serving one query.

For the memory issues, please start your own thread, but here are a few links:

http://blogs.msdn.com/slavao/archive/2005/02/19/376714.aspx

http://blogs.digineer.com/blogs/larar/archive/2007/07/15/memory-pressure-on-sql-server-2005-64-bit.aspx

I haven't worked with VFP in some time, but the code for getting to VFP files and going to SQL Server wasn't much, if at all, different. You could have...

I'm confused? Lynn, was the post edited?