Changing the database owner doesn't change permissions on objects, but it does change the ownership of any objects already owned by DBO. IMO, it's a good thing to have...

If you set the job step type to "SQL Server Integration Services Package", it will prompt for the password when you click on any of the tabs will insert the...

I've noticed people have trouble deleting posts. It seems they often have to ask the administrator to delete them.

I think your idea of saving a copy to another location is a good one. You might also consider saving the package with the Protection Level set to DontSaveSensitive...

If it is a permission problem, it's most likely because of the package Protection Level. See this thread for answers to a similar problem:

http://www.sqlservercentral.com/Forums/Topic619676-148-1.aspx

Please dont' double-post your questions. Answered in this thread: http://www.sqlservercentral.com/Forums/Topic619676-148-1.aspx

That's the message you get when SQL Server Agent doesn't have permission to run the package. The Protection Level property of the package is probably set to the default...

You can't make a stored procedure a member of a role and only logins can be members of a server role. You might look at EXECUTE AS in Books...

Does everyone need direct access to SQL Server or is there an application layer between the users and the database server?

Hopefully, the application uses stored procedures in SQL...

You can get that info from the default trace. Here's an article with sample queries of the trace: http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/. You can also see the most recent changes in SSMS...

Try giving TargetServersRole permission to execute sp_help_jobschedule in msdb.

Oh, I see. I had the impression you were trying to execute a previously saved package.

I should add that another common way of executing a package on a server...

This explains the error you're getting and what to do about it: http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

You have two choices:

1. install Integration Services on the workstation and execute the package from there....

I don't think I've had that happen, but could you provide the error message and schema of the source and destination tables? Also, a description of the DTS package...

I've found that this is expected behavior. Preview doesn't work for a query that contains a parameter because, even if you've assigned a value to the global variable, that...