Have you looked in BooksOnLine? From BOL 'Create Database (Transact-SQL):

Permissions

Requires CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission.

To maintain control over disk use on an instance...

It's normal behavior for a database to remain at it'a original compatibility level after being upgraded to SQL 2005. sp_dbcmptlevel is the correct way to change the compatibility level....

You didn't mention if the packages are stored in SQL Server or in the file system. An advantage of storing packages as .dtsx files is you can copy them...

You'll need to change ProtectionLevel to EncryptAllWithPassword or EncryptSensitiveWithPassword, supply the password in the command line in the job step or in a config file, and grant the login that...

DTS Packages will still work in SQL 2005. Packages are not automatically upgraded when you upgrade to SQL 2005 and if you migrate i.e. transfer everything from a SQL...

Is SQL Server Agent running? If it is, what do you see when you expand it?

I agree with Jack, but you'll have to figure out...

You can create a 'master' package that has 10 ExecutePackageTasks, one for each package you want to execute. Then, you can just execute the 'master' package.

I suggest you make sure logging is enabled in the first child package and step through it like you did with the master package. If the step that is...

If you set the package ProtectionLevel to EncryptAllWithUserKey or EncryptSensitiveWithUserKey, you're the only one who can execute it. You'll have to set ProtectionLevel to EncryptAllWithPassword or EncryptSensitiveWithPassword to...

Is Builtin\Admininstrators a member of the Sysadmin server role? If you want to restrict the permissions of the DBAs in particular databases, you'll have to remove Builtin\Administrators from Sysadmin...

You've just revealed some new information. So there's a master package with 5 Execute Package tasks. Do each of the child packages have logging enabled? Have you...

USE dbname

CREATE USER Scott

FROM LOGIN Scott

SP_ADDROLEMEMBER 'db_datareader', 'Scott'

Do the same thing for smith.

You could try the Transfer Jobs Task in DTS. I've only used it once, so I can't offer much advice about it. I've mostly used scripting.

Try changing WHERE DATEDIFF(dd,CONVERT(VARCHAR(8),sjh.run_date), GETDATE()) <= 1

to

WHERE DATEDIFF(hh,CONVERT(VARCHAR(8),sjh.run_date), GETDATE()) <= 1