You can periodically cycle the logs without rebooting. sp_cycle_errorlog or something like that will work. I had a server that never went down and we had the same issue, so...

correct, you do need to drop the assembly, but not the function.

Thanks for the reference above.

Very nice Frank. I'd be willing to work on your code if you need help

sp_start_job called through isql or osql

You have a few moving parts here and I'd tackle them separately and get each to work.

For the moving of the files. You need to use an ActiveX script and...

Sorry, haven't gotten it working here either. I suspect I'm missing some files somewhere.

I'm not sure what might cause it, but it's probably a runaway process somehow and a restart is the only way to remove this.

Are you still getting entries in the Windows eVent log? It's possible that there may be some issue with that particular installation. I saw a couple entries recently on the...

Is it every time? I've had this happen on occassion with some servers or workstations. Have you traced to see where the slwodown might be?

Good point. I'd forgotten about it, but unless it will emulate an x86 chipset or there's a port of Windows, not sure it counts here.

SPIM is spam through instant messaging. I've been hit a few times, mostly someone sending a sentence and a URL through.

My partner, Brian Knight, wrote a nice one called Admin 911, I'd also say that if you're interested in how and why the server works, Inside SQL Server 2000 by...

Agree with Phil. Especially the avatar

I know of people running more than 2TB. Guarentee that 2TB is not a limit. Not sure about 1TB on Std, never gotten a db on Std to that size,...

I might have separate insert procs for each table and then an overall "uspCustomerAdd" that might call a couple of these to ensure a complete customer record is being inserted....