Can you check these settings using REGEDIT

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\[yourinstancename]\SuperSocketNetLib\Tcp]

and

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\[yourinstancename]]

can you post you job's DDL ? (full)

btw don't use a domainadmin account to run your sqlserver !

    Keep the guideline...

first check that your sqlserver agent service account has the needed rights to you networkdrive.

I use this doscmd to do the job (without problems)

XCOPY C:\MSSQL\BACKUP\*.* \\myserver.mydomain.com\bu2tapeDay$\mysqlservername\Database\ /c /s /k...

just my 2ct

how about ...

Select inv.*

FROM dbo.Inventory inv

where not exists ( select *

                         FROM dbo.InvHist IH

                         where IH.InvID = inv.InvID)

These are some items I've added to the great doc :

(formatting is not what it should be in html )

1.1   ...

just my 2ct to add to Daniel's reply :

another downside with DTS it when there are schema-changes !

IMO for this prod to...

in sql2000 that would not be needed because your image col is just a pointer in your table. That pointer points to a blob address which is like a varchar...

From Books online :

sp_pkeys

Returns primary key information for a single table in the current environment.

Syntax

sp_pkeys [ @table_name = ] 'name'

    [ , [ @table_owner = ] 'owner' ]

    [...

There is no "out of the box" data-encryption within sqlserver 2000.

you can however encrypt you code (e.g. create procedure , create view, ...) using the with encryption keyword.

Check Books online...

You may want to run sp_updatestats and dbcc updateusage() before you collect and interprete these statistics data ! 

(Check books online !)

Plan it in...

indeed, once you are sa, you are a "god" for sqlserver.

You cannot deny sa anything !

If you remove builti\administrators, make sure your sqlserver (and agent) service account is a local...

IMO your user has SA-authority !

The only way a non-sysadm user gets rights to a db...

Another downside of sp_rename for stored procs is that it does not alter the create-text !!!!

So when you script your db using SQLDMO or other stuff to readout the...

is this an sp4 instance ? (we plan to upgrade to sp4, just inventoring what to expect)

Using isqlw.exe (or osql.exe) (i cannot recall wich one is provided with msde) you can perform something like this :

create a script like this

-- allow serverlogin

 exec sp_grantlogin N'windowsdomain\windowsuser_A' --...