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?

says the Scary DBA

A very good DBA can get by with SQLCMD (or isql/osql), but why should they? I loved QA, which required command line work, but it also gave me many features...

I'm with GSquared on this one, even if he doesn't trust me :w00t:

People deserve respect from the get go. They can lose that, and need to earn it back, but...

Good to know I shouldn't scan clustered servers.

I think SQL and Exchange can be finicky. Exchange has some scanners built in for content, but I think I'd be happy to...