The way you have things written, it's a very minor overhead. You are only running one statement.

If things are slow, be sure that you have good indexes on this table....

No idea where to get avatars. I've usually snagged photos and cropped/blurred them. My current one is my daughter and I in the car, but you can't make us out.

Yours...

Classes aren't required. The books aren't really either (and that coming from an author!), but the books do help you focus and go in some order for things relevant for...

No pay. It's the price of having a wife that loves horses.

Hey, I mess up the QODs as well as edit the content here.

I installed Red Hat on an old laptop a couple years ago. I didn't really have any issue with the install, the Browser and email clients worked fine.

But they weren't...

Check the Windows error log for the reason it won't start. Likely it's security.

No tricks. works like other services. The Service account does need to be able to log into...

Here's some notes. A little dated, but they should work for 2000.

http://www.sqlservercentral.com/columnists/sjones/20010422115752_1.asp

http://www.sqlservercentral.com/columnists/sjones/20010422115754_1.asp

Especially check with Windows as mentioned above.

SQL should be fine, but watch performance as Michael mentioned. things change with multiple processors. Should work better, but watch it.

Also, search out "errorlog" on your system on all drives and be sure they're not getting put somewhere weird.

Are they also not appearing in EM?

The only kegs coming back to Denver are Guiness if I can get across the stream to Ireland. Other than that, I'll stick with my Corona from the border below...

Sam has defined it, but in SQL 2000, you had a database, say Sales, with a table, say MyTable. The owner of the table was usually dbo, but it could...

encryptbypassphrase() works, but a better method is to create keys and use those for encryption. That way you can assign rights to use the keys to users.

I had some issues if I used different extensions as well. Be sure you're patched beyond SP2 with the fixes, and check your paths. There are some strange things in...

As much as I like Joe's description, Brandie, I think you've got a good description there.

Can you post the code you're running? My guess is you're using c:\program files, which means there's a space there. You might need to use quotes around the string.