They could use SP_HELPTEXT stored procedure or OBJECT_DEFINITION function. I think either one only requires membership in the PUBLIC role to work.

I like an uncluttered inbox; maybe not zero, but at least not more than one screen full. I have several "subject" folders with subfolders under them where I put...

I've done this exactly the way Jack describes and it does work. The "deny" for the individual overides the "permit" for the group.

Yes I do. I think you'll be less likely to have steps missed by reading well-organized and thought out articles than by having someone list the steps off the...

I've used this script for years to figure out the insert/delete order of tables with foreign keys. I haven't had time to change the SQL 2000 system table names...

How you handle a failed job really depends on what the job does. As Jerry said, some failed jobs can be ignored because they'll get caught up on the...

That's a pretty in-depth subject. Have you looked at any of the documents/resources available here?: http://www.microsoft.com/sqlserver/2005/en/us/upgrading.aspx

My first suggestion is for you to review the information above then post any...

No chance. If you don't have a backup, it's gone.

Sorry, I used the DTS task name. I haven't actually used the task in SSIS, so I can't offer any advice about it's use, but a search on this...

The schedule is included in the job script. You don't need to create anything separately.

I get the same error. I don't know what causes it, but I suspect it has something to do with the objects being in SQL 2005 because it works...

If you're not comfortable creating a DTS package, you can script jobs in Enterprise Manager:

Management -> SQL Server Agent -> Jobs

Right-click on a job or jobs -> All Tasks...

...but only in SQL 2005.

You can't restore a backup of a system database (master, msdb, model) that was made in SQL 2000. See "Copying Databases with Backup and Restore" in BOL.

When you open a package I Business Intelligence Development Studio, Protection Level is shown in the package properties. That's where you can change it. By default, it's always...