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.

I don't think you have updatable subscribers with log shipping. That's with replication.

Both mirroring and log shipping work in similar fashions, by applying transactions to the secondary server. Mirroring allows...

Paul's posted here as well and his blog is here:http://blogs.msdn.com/sqlserverstorageengine/

I pinged him with this thread, so you may see a response here.

No hugs from Grant

I'm actually going to Cambridge for a Red Gate visit, and not sure I'll spend any time in London. Out...

I'm not sure of where you could get the DTS internals, but one thing that might help is to save as a "VB File" and then execute it in a...

You can set them to auto-close if you think they aren't being used and then if they get accessed, the log will reflect it opening. Don't do this for systems...