The only way I know is to have a DDL trigger enabled for CREATE_LOGIN.

That's right. When you create a job, you're the owner, but it executes in the security context of the login that runs the SQL Agent service.

You can create a...

Kind of late with this response, but here goes.

I suggest you download and use DTSBackup 2000 written by Darren Green. It's free and it works greate for transferring all...

RE: The DTSRUN arguments.

/G and what follows it is the package ID. Each package has a unique GUID as it's package ID.

/W "0" specifies that...

Since we like our databases to be owned by sa, I just run sp_changedbowner 'sa' after the restore.

bengchoo.kuah (5/13/2010)

---

Thanks for your reply. I have a couple of queries pertaining to side-by-side migration which needs your expertise / help.

1) If we install MSSQL2005 on the same server as...

I've always been cautious and done side-by-side migrations rather than in-place upgrades, but these should help you:

http://msdn.microsoft.com/en-us/library/cc966519.aspx#EGAA

http://download.microsoft.com/download/b/8/4/b8463723-c3b9-439e-828b-50d7981d5d26/FY08%20SQL%20Server%202005%20Upgrade%20Customer%20FAQ.pdf

Because it runs as a service, not part of a SQL Server instance, you can only connect to it with Windows authentication.

The AUTHORIZATION argument designates the owner of the role, not permissions. Since a role is a database object, it must be owned by a user or another role.

The role's...

It should be here: C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC

Is this a Litespeed backup? I haven't seen this error myself, but I googled it and found this thread among others: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82654

Another security difference is that you can use the Integration Services roles in msdb to manage permissions on packages stored in SQL Server. They have no effect on packages...

Here's another:

http://www.sqldts.com/242.aspx

What do you mean when you say it looks like a different version of the package? Does it have the same tasks and workflows, but the layout is different?...

Just to verify: did you make the user a member of the role?