Lots of scripts listed here: http://www.sqlservercentral.com/Scripts/Security/. Take your pick. I've used versions of several of them.

Can you open them in a remote connection to the server? It could be a problem with the client installation on your PC.

Sorry, I can't see the complete thread title. Could you put you question in the body of your post, please?

If you want to transfer jobs between instances,...

Can you tell us which of the error messages you got? If you got the one referring to DTS Designer components, did you install them?

Try granting EXECUTE permission on sp_help_job and maybe sp_get_composite_job_info in msdb.

Everyone using the same login(SQL Server login?) makes it difficult. I think this would be recorded in the SQL Server error log, but if nobody connects using a Windows...

Interesting. I was able to provide the password in my job...

If you set the job step type to "SQL Server Integration Services Package" instead of "CmdExec" and use a proxy account, you could reduce the permissions required to run the...

Have you looked at the SQL Server Agent fixed database roles in msdb? Although I haven't tried it, it sounds like the SQLAgentOperatorRole would fit your needs if you...

DTS is used to import and export data to and from databases. It has been replaced by SQL Server Integration Services in SQL 2005.

Replication is used to keep the...

Use IF...ELSE instead of CASE for conditional logic outside a SELECT statement.

I think you'll have to either do them manually in Enterprise Manager or script them out of sysmembers in TSQL.

You probably saved the package with the default protection level EncryptAllWithUserKey. That means that only the user who created the package can load and execute the package. When...

The only way I've been able to do it is to drop the role and recreate it.

You could use a query like this that checks sysjobhistory:

select distinct j.Name as "Job Name", h.run_date as LastStatusDate,

case h.run_status

when 0 then 'Failed'

when 1 then 'Successful'

when 3...