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

What do you mean by suffer? Slow down because of load?

You transfer over log records, and that takes some overhead. Not much, very little, but there is some slight overhead...

Apart from what Jack has asked, we do that here. Articles are versioned and we have an "active version" and then all previous versions. A field signifies which is the...

Are you restoring to the same files? Creating this many files might take time.

Why so many files, out of curiosity? Seems like extreme overkill and an admin nightmare.