Yes, you can script these. Manually scripting 100 or so would be pretty monotonous. Why don't you write a little VB using the SQL Server API to script them all?...

I assume you mean running the jobs as yourself, manually when you say they work when running seperately.

Is it possible that the job owner doesn't have sufficient privileges to run...

I've been through this before with one company I worked at. In the end, the DBA and Server teams settled on an account with these privileges that we could "check...

Have you tried: "Be made using the login's current context" and then have a user who has sufficient permissions on both servers (Probably you) tried to browse the linked server...

Yes, it does. I looked in SQL 2k5 and 2000 BOL and couldn't find the amount, for some reason I thought it might be 4 bytes but I can't remember...

I'm going to need more details. Just to confirm, are you using SQL Server 2005?

What do you have listed in your security tab? Did you set anything up?

What server type...

Hi there,

If I read your post right, it looks like you are trying to set up a linked server using Builtin\Administrators as an account. (Correct me if I'm wrong)

Builtin\Administrators is...

Is there any reason you aren't running them in Query Analyzer or SSMS? (You didn't indicate a version) Are you trying to automate the process or is this a one...

Agreed what I'm suggesting is only as a last resort. I've seen companies send people on planes with backup tapes to do this before...

Steve,

Agreed, its a pretty tall task and what you suggest is by far preferred over what I'm suggesting.

If yulichka compresses it with a backup compression tool such (Redgate, Quest, Idera,...

Ok, thats what I suspected. The owner of the DTS package isn't important in this case, its the job owner that is.

From Enterprise Manager open Management | SQL Server Agent...

Thats better. 🙂

Out of curiosity, why do you want to change the owner of the package? As far as I know this doesn't actually mean anything.

Chris.

Hi,

Can you provide specifics? I'm not sure what you mean by "database package."

Are you trying to change the owner of a Database, a DTS or SSIS package or a...

Here's how I remove the free space from a database. This is a logged operation so I switch to simple mode before I run it.

dbcc shrinkfile([data file name], [Desired size])

You...

Do you mean, can they shrink the database with users in it?