Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2005-10-25 : 03:53:05
|
| I have a lot of developers in my IT. And they have created a lot of DTS packages. So, they have problem to change smth in packages of theirs colleges because they are not a member of sysadmin role and they are not owners of those packages.I decided to create one login (for example 'dts') for this purpose, and to change all owners to new.I use undocumented proc sp_reassign_dtspackageowner and it changed owner and owner_sid in msdb..sysdtspackages to 'dts'.But .. When I logon in EM with new account ('dts'), and make change on some existing package, it make new row in sysdtspackages but with owner which is different (my domain account) and with owner_sid which is SUSER_SID('dts').I don't want that. I want everything to be 'dts'.Any help ? |
|
|
Mariory
Starting Member
5 Posts |
Posted - 2005-10-25 : 05:55:19
|
| I may be wrong but the owner of a package cannot be a SQL Server or Windows System/local account. The owner of a DTS package will always be the user account logged in to windows when the DTS package was saved/created. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-25 : 06:03:30
|
the owner can be a standard login or windows account that has access to the serverquote:
Originally posted by Mariory
I may be wrong but the owner of a package cannot be a SQL Server or Windows System/local account. The owner of a DTS package will always be the user account logged in to windows when the DTS package was saved/created.
--------------------keeping it simple... |
|
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2005-10-27 : 03:52:30
|
| Maybe Mariory is not wrong. I have a problem to create DTS package and standard login to be owner of it. I logged in with 'dts', in EM, and create completely new package, save it, and owner is my Windows domain account. How could standard login be the owner?----------------------------------it is not so simple ... not for me |
|
|
|
|
|
|
DTS - problem with owner