If you are using Windows Auth in IIS, then you add the people to the SQL SErver using their windows accounts. If you don't want AD groups, I'd at least...

Is the year correct?

Is this for development? Or admin? for admin, have them create a db, back it up, then restore it as a different name.

for development, have them write a report you...

Are there multiple files for the data? You can use sp_resetstatus, but you want to resolve the issue that caused it to be suspect. Perhaps a file was locked by...

A torn page usually means an incorrectly linked page in the file. Likely the file itself is corrupt somehow. I'd get Backupexec and MS on the phone ASAP to work...

You need to talk to people that do this sort of thing, like NasDaq, Dell, etc. People that need to handle high volumes with high uptimes on MS technology. It...

Separation. We had to move the email server to a separate location from which we can send the newsletter. Took some tinkering, but we basically have 1 T-1 for the...

Are implicit transactions turned on? Haven't noticed this, but I don't do much XML work. I'll have to take a look.

Test your restore in QA, then take the script adn put it in the -Q parameter as shown by  Amit above.

I've had a number of 4GB machines and they never go above 1.7GB. It seems that the server algorithms that balance memory with the OS max out here.

Not that I know of, but you could use VBScript and SQL-DMO to execute quries for a DBA.

That's a good question as to whether the defrags at the OS level help. If you could preallocate teh space, then at there shouldn't be a problem at the OS...

That is strange. Most likely the regional settings aren't applied until someone is logged in. Can you log in as the SQL Server service account and set the settings for...

Antares has the best suggestion. Follow his advice.

Windows 2000 SP4. At the end of thus year, all support for NT 4 goes away. While the OS is fairly stable, there are still security issues being found and...