While you're in the writing mood, write one to Willie Nelson for me.  I'd kinda like to play a round of golf with him.

As a child, I was fascinated with war.  My friends and I would spend hours every day fighting “the Japs”, “Indians”, or, being a good...

Since the column is datetime data type, it stores date/time date down to the millisecond.  Assuming you're only interested in the MONTH, you can use DATEPART to strip out the...

You may need to change the owner of the DTS package?

I don't have a SQL 7 installation to test with so can't give you any advice on 7.0

You could try installing the SQL 2000 tools which should give you this...

What data type is Month_of_file?

Assuming it's datetime or smalldatetime, you might want to experiment with the DATEPART function.

I got around this security concern by creating a SQL Server login with SA authority.  Then create a .bat file which runs the dtsrun command line utility (encrypted) using this login.  The...

I'm not going to start swapping arguments here.

They had rations.  Whether or not they used them effectively is up for grabs.

The POINT is, a person can live for 3 weeks...

I'll play "arm chair analyst", not to criticize, but to educate...

You can live:

3 minutes without air (they had plenty of the fresh stuff)

3 hours without warmth/shelter (they were able to...

Let this be a lesson to the green horns of the world.  Get lost?...stay put!  If he had, he'd already be found.

This episode is testament to the relative value companies (and people) place on human life.  For this one "good" example, there are certainly many "poor" examples. 

DBArtisan is my favorite.  It gives you a bit more flexibility (specifically with triggers) than other tools I've used.

might want to check this out:

http://msdn2.microsoft.com/en-US/library/aa337126.aspx

Technically, NONE of the provided answers are correct.  I thought we'd gotten beyond these bogus questions

Ladies and Gentlemen,

How much more ambiguous can these questions get?  We are dealing with computers here; 1's and 0's!  If a computer cannot be completely definative, WE'RE ALL DOOMED!  I'm...