Thanks, I like the idea of several questions ranked in difficulty.  I've got resumes from people of all skill levels, from a MySQL web developer to a very experienced DBA.

For log shipping, I think many people here would agree that rolling your own is the best way to go.  I wouldn't think that a 1 minute latency is required...

I worked at U.S. Borax in the research department in the late 70's.  We used a process control system that was programmed using a dialect of BASIC, with two character...

Not would more correctly be described as a logical operator.  It will give you the bit-wise inverse of the expression that itt applies to.  So, if A = 1, Not...

I'd like one of those, too.  Write it in T-SQL.

When will it be done?

I found the solution in an article about VisualInterDev or something odd.  The stored procedure would return a recordset when there was no error, but none if there was an...

This is going to drive me nuts.  As soon as I added a second output parameter, the values again failed to come across.  I thought that, perhaps, there was something...

I have no idea why, but I started getting output parameters back this morning.  I think my stored procedure was generating an error, which may have caused the parameters to...

The stored procedure works fine in QA.  @param1 is the name of the parameter for the sp.  The value gets sent to the sp correctly.

It would really be nice if someone were to write a tiny and free MAPI client that would replace Outlook on SQL Servers.  And when you do, make it open...

Wouldn't you want to allocate about 10 GB to SQL on each server? 

I've been thinking the same thing, lately. 

From the responses, it looks like the software vendor is either: 1. Used to working with version 6.5 , or 2. Blaming something else...

Win 2K3 and SQL 2K SP4. 

I have a first edition MS Press study book, which you can have for $25, including shipping, unless you live in Australia or Romania or someplace outside of the states.