If the departments are consistent throughout the resultset you could just use

UPDATE TABLEA

SET DEPARTMENT = 240094

WHERE WEEK = 7

Why not use sp_helprotect? I have this with a couple of DTS packages that back up all the permissions nightly and allow me to restore those permissions to any point...

When you first connect to SQL it attempts to poll the server to check the state of the services, this can be a problem if you are running with SQL...

Make the final step of the job a call to a dts package that shells out to dos and uses ftp to upload the log file.

Check out the utility for backup and restores of DTS pacakges out on http://www.SQLDTS.com

On the server that you are restoring to drop and recreate the logins with the sids matching the login sid on the first server, that way you won't run into...

Had a developer come up to me yesterday and tell me that he wants to add a varchar(8000) column to an already wide table....

Tymberwyld think yourself lucky Only 134 columns. I inherited a data infrastructure that is a nightmare, and I'm not in a position to...

Unfortunately the package is lost...

1. Nope, datafiles are for use by a single database, why would you want to share the file?
2. Check what is being run, you could have a cross database query that is...

You have no backup of the MSDB database?

Locally you can restrice access to MSDB which would help prevent them from creating a dts on the machine, however they could still create one on their own machine. Other...

You could use alerts to run a job on failure, however I have not been able to figure that out myself.

Another option is to put a trigger on the msdb..sysjobs table...

Your new view is running multiple joins against other views that could well be doing joins against multiple tables. Check the other views and see if you are exceeding the...

Why not place a step at the end of the job to send out notification that the update is complete? Or assign a trigger to the table to log information...