the log will truncate at a checkpoint, sql server will decide when best to do that , or not, try issuing an explicit checkpoint.

ntfs fragmentation is not good, especially for data files, log files by their nature may tend to fragment.

W2003 will allow an online defrag but you wouldn't want your users connected....

revoking public rights is quite a good move but there are some issues - you obviously move away from an "out of the box" install - this means if things...

think it's something to do with small tables that fit in a page or two. I spent ages trying to get one to improve from 50% and decided it was...

I'm sorry but it's difficult to say for sure, I don't really have any experience of access - but 11 years sql server says it doesn't sound right! Perhaps another...

I know what code is running, I was interested in what was happening in tempdb with regard to workfiles and such - it's just I couldn't find any refs to...

There are a number of ways you can handle this - there are some whitepapers about this - you might like to check out http://www.sqlsecurity.com/

My preference would be to...

or you could upgrade to 2005 which has ddl triggers.

seriously though I agree with  Clive - restrict your users who can issue this command.

You can capture this event with profiler,...

I'd seriously disagree about the speed increase ( in real measurable terms ) I'd say you'd struggle without a DC.

notwithstanding the debate about security of the connection method I'd say...

tricky to be sure - you might want to make sure you're not short of disk space or suffering from ntfs fragmentation in the snapshot/transaction folder. You might want to...

how will you schedule your osql job?

I don't really understand why you would see heavy use of sp_helpuser and I don't know why it should block, if at all. You don't say how you're getting your...

that'll be it then! Transactions are best made as small and as quick as possible

to be honest there's little point as anyone can download a proc to decrypt them. .. but -- script them all out and do a find and replace on the...

well any explicit transaction will block for the duration of the transaction - is the proc blocking itself or other sql?

I note that your proc doesn't include any rollback in...