just a wild guess, but did you remove builtin\administrators and forgot to give login auth to the cluster service account ?

tell him to use Visual Studio , create a new SSIS project and use the migration wizard for DTS 2000. (he must be able to get to the SQL2000 package...

can you script and post your "create linked server" DDL (and the details) ?

Did you check ApexSQL Audit ?

If you have full recovery model enabled, there are also log-analysers on the marked. e.g. Red Gate Log rescue (btw free for sql2000)

What level is your SQL2005 (sp2 with CU3 ?)

- check the job-owner for the jobs.

- if you want to run dts-packages, you'll need ssis

   SSIS needs to be installed separatly...

keep in mind that to be able to create a linked server (from SQL2005) to SQL2000, you need to run an extra script at SQL2000 side.

KB ref at http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

Indeed, that will work.

But the guidelines are to migrate the packages to SSIS properly.

They will migrate, even if that means having an incorporated dts2000 package!

If you use the migrations wizard,...

As already mentioned sp_change_users_login is what you need to sync the db-user-sid's to the server user-sid.

To script the SQL2000 users with their passwords use this on your sql2000 side:

select 'exec...

With BI-dev studio you can create a new project (BI / Integration services project) and then migrate the existing DTS-packages !

Project / Migrate DTS 2000 package

Alen's written a good article on this ...

Building Alert-based Transaction Log Backups - Part Two 

"select * " indeed is one of the worse practises !

just my 2ct

- with SSMS you can script practicaly every action you perform.

   So, Design your table and push the "script changes" button.

   (and the ofr corse cancel...

indeed.

Little things you forget when you quickly try to do a last thing of the day

Since SQLServer manages that frequency itself, there is no exact number.

Search Books Online for Checkpoint info.

If you want to be able to perform a point in time recovery, you NEED your database to be in bulk- or full recovery mode !

Having your db in simple...