No problem   I hate saying "you shouldn't do that..." to people because it always turns out they don't have a choice in the...

Some RAID levels that implement striping can improve performance.  Choosing a RAID level usually involves a trade-off between performance and reliability though.

Putting the log file on a separate drive helps because the...

OK, so let me make sure we're on the same page:

1.  You copied the file xp_dirscan.dll to the MSSQL\BINN directory for the instance of SQL Server that you want to...

Personally I prefer to store images in the file system and store a reference to the file in the database.

If that's not an option, here's a really good article on...

Oops, brain fart.  Sorry about that.  If you're using SQL 2000 use ALTER DATABASE to move TempDB.  Sorry about that, I had a 6.5 flashback.

But the better option for the...

To move TempDB to another device, first put TempDB in RAM, then move it over.  Here's an article:  http://support.microsoft.com/kb/q187824/

Like I said, this would be one of the last things...

Hard to say.  There could be a lot of factors affecting your server performance.  Putting TempDB on its own drive might help, but I'd there are usually other things that...

Yes, @@Version doesn't seem to be too reliable...  I actually wrote a small .NET app once to interrogate the registry and pull up the correct service pack version number of...

He might have meant it to be an integer value, but since he's using ASP (not ASP.NET) he's probably using the Variant data type.  So there's no strong type checking and...

No and No.

I mean what I said:  pid = "';DELETE FROM table; --"

Let's assume lngRecordNo = "2", for the sake of argument.  If you look at...

Sharks with friggin' lasers on their heads?

*= is deprecated because of ambiguity the operator can cause in some queries.  Avoid *= operator, as it is not ANSI standard and will probably be dropped in the future.

& "and EatingID = '" & pid & "' "

Also look up Parameterized Queries in MSDN Library.  The method of appending strings like this opens you up to SQL Injection...

Lots of money, complete creative control, a personal assistant to pick up my dry cleaning, a bowl of M&M's in my dressing room (all red ones taken out), and a...

Reinstalling SP3a shouldn't cause a problem.  You can look in the registry to find out the real service pack installed, under HKLM/Software/Microsoft/MSSQLServer/MSSQLServer/CurrentVersion/CSDVersion.

AFAIK there are also methods for checking the version...