The funny thing is, the author obviously realized that nvarchar takes 2 bytes per character, judging by the explanation:

To mis-quote Simon Cowell...

Thankfully, this has been fixed in Vista - the reminder message is now a balloon-tip from the system tray.

If you have 2000 SP3 or XP SP1 or higher, you can...

This sounds like an example of the "Secretary Problem":

http://en.wikipedia.org/wiki/Secretary_problem

Apparently, the first (and only) CTP of SQL 2005 SP1 has just been posted:

http://blogs.msdn.com/euanga/archive/2006/03/16/552349.aspx

Some other problems using SSMS with a SQL 2000 instance:

• You can't view or modify multi-statement TVFs. If you try, you get an error message indicating that you don't have permission to access...

"The customer lists all the features they want in priority order."

And how often can your customers tell you exactly what they want, let alone as a prioritized list?

If you are...

I've got the same issue. Looks like the person who posted the question has realized their mistake, and swapped the answers round.

For string values, you can use two ORDER BY clauses:

ORDER BY
    CASE
        WHEN 'descending' = @SortOrder THEN Column1
  ...

Speaking of security risks, how about this line:

_topic = new String(request.chktopic);

...

var sql="!nocache:execsp usp_setcontacttopic "

... + ", '" + _topic + "'";

That's a great way to leave your...

Unfortunately, Microsoft have chosen to only make this product available in the US and Canada. The UK sales office "are currently awaiting confirmation from Head Office as to the availability...

The information on CONTAINS was updated in the Sept. 2001 update to BOL. This may have been one of the updates. I have successfully used CONTAINS with a variable in...

If you do need to run the script near midnight, you could use:

exitTime = DateAdd("s", 60, Now())

Do While Now() < exitTime

...

But: This script seems to peg the CPU usage at...

Using recursion is an un-necessary overhead. You could achieve the same result without putting this much strain on your stack by iterating through an array:

Function CreateFolder(Path As String) As Scripting.Folder

Dim...