What errors are you getting?

Or look at the execution plan for the proc...

How about a maintenance plan on the system DBs?

An output parameter on a procedure will only allow you return 1 value, so if I'm reading this correctly you'll need to drop the output param (@ID) on the procedure.

insert...

You can open a support ticket with MS, submit the dump file, etc....

It looks like the problem is usp_GetSecurityScreenID.  Take a look at the procedure and any tables it touches,...

You can do a double convert on GetDate() to get the time stripped off...

SELECT ARJOBHD.INVNO, ARJOB.PRICE, ARJOB.FRTAMT, ARJOBHD.INVDATE

FROM ARJOB INNER JOIN

ARJOBHD ON ARJOB.INVNO = ARJOBHD.INVNO

WHERE ARJOBHD.INVDATE > CONVERT(DATETIME, CONVERT(VARCHAR, GETDATE()...

'00001234' converted to a number will yeild 1234.  How about dividing by 10000 on the file import?

This is a good question I'll be curious to see some other responses.  Here's a stab to get you going...

Of course, you'll have to look at your current servers...

What DBs...

Assuming you meant SQL Server 2000.  I'm running Outlook 2003 on my WS with SQL 2000 with no issues.

Did you set up the mail profile for SQL Server Agent?  From...

Kathi is correct about the transaction logs.  You may also want to look at the scheduled jobs.  From Enterprise Mgr..Server..Management..SQL Server Agent..Jobs.

Most of the installations I've seen make use of...

From QA... KILL spid

You can detach, move files and reattach, but Cory was asking about moving logins, jobs, etc... as well as the data.

I haven't had to move logins, let me know how...

It depends on how much you have to move.  My thought would be the best way would be to back up master, msdb, and your databases and restore on your...

Was there more to this error message?  Did replication ever work?

Did you check out the replication monitor?

Not sure I completely understand your Sys Admin's concerns.  The point of write cache is to ensure the data does get written to disk.

Temp DB should always be on it's...