Thanks!

1. order in the WHERE clause does not matter.

2. What's the dat? This doesn't make sense in SQL Server.

3. Not sure, might depend on the isolation levels set on the...

Haven't tried it, but this might help you: http://www.sqlservercentral.com/scripts/Miscellaneous/31062/

I'd suggest you do some reading at the SQLCat team's site at: http://sqlcat.com/. They do a lot of work with large installations and you could get some data there.

As far...

You can capture the new database using a DDL trigger or an event notification. If you store that data off in some table, then you can track it. You can...

You could compress them, but you'd need to either Sp_OACREATE to grab an object handle to some zip utility or shell out (xp_cmdshell) to do the command line call.

You might...

You could always start one :w00t:

You have to try and collaborate, try and help, but at the same time you have to meet your responsibilities.

Management has to see this, perhaps by dividing responsibilities and letting...

I have friends who think that outtakes are the editorials!

You and my kids like those the best.:hehe:

I'd argue that having command line options is a part of usability. Just like every program I wrote years ago had to respond to "/?" from the command line, just...

Not sure about the Java driver, but that typically is a communication/network type error.

3.24GB of RAM? Is this a 3GB or 4GB machine?

There are no real configuration settings that you need to change. However it completely depends on what you are doing with...

It's not that I don't want to go uphill, but there doesn't seem to be much uphill and close to the convention center. Much more if you head down towards...

I'll second the advice above.

Users have no rights to tables unless they are granted. If they are granted as part of a role or rights, then you can use DENY as listed above.