You cant add dates together and expect a reasonable response. 

 SET fac_send_date = DateAdd(day,fdate_cnt, f.book_date)

                    + DateAdd(hour,fhour, f.book_date)) 

                    + DateAdd(minute,fmin, f.book_date) 

This statement really says add a day to some date, the...

I assume that this user will be the only one using the database.  When he wants to restore noone else can be using the databases.  So rather than connect to...

Hmmm.  Have you tried dropping the SEM4 database (don't create a new one at all) The use the 'sp_attach_single_file_db'   to attach only the MDF

Its sounds like a awful problem...

 The LSN is a Log Serial Number that basically identifies each individual record in the log.  It may have a problem of sorts.  If you have a single MDF file...

Are there other jobs running at the same time as this one? 

If you suspect recompilation, you can use Profiler to trace if your stored proc is recompiling

Interesting question.  I couldn't figure it out without some research.  I hope Microsoft adjusts this behaviour in a future release.  I hate to have to implement a solution like this...

Adding resident_id to the household table would denormalize the table, since now we must repeat the address for each resident, potentially leading to inconsistant data.

Did you restart your workstation?  If that didn't work, did you try uninstalling all SQL Server 2000, restart your machine and reinstall?

Please explain.  Jobs are jobs.... users are users.  Job histories belong to jobs period.  There is no relationship between jobs and logins. 

Basically add  

CREATE TRIGGER <trigger_name>

AS 

at the beginning for a proc and

 CREATE TRIGGER <trigger_name>

ON <table_name>

FOR DELETE, INSERT, UPDATE

AS

See BOL for more information.  If you are using Query Analyzer from...

When you add a new person you need to add to the resident table and MAYBE add to the household table.  You do not add to the household table if...

I take it you tried executing sqlservr with the -d, -e and the -l options and it didn't work.  Did the -f option help?

My guess is they meant do not install the terminal server on the same machine as SQL Server, but its ok to use terminal services to access the SQL Server...

Depending on the change it might be a bit much, however I wish our site had that much control over what goes on the production server.  I don't like to...

If statistics don't get periodically updated, then changes to tables size that may affect access plans aren't taken into account.  Try running sp_updatestats. 

No indexes doesn't sound good.  Your right though,...