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 |
|
Juls
Yak Posting Veteran
51 Posts |
 Posted - 2004-04-26 : 15:39:08
|
| Hi,I have a DTS package that I created while I was logged in with NT Authorization using Domain1\Juls.Then I ran EXEC sp_reassign_dtspackageowner @name=@name, @id=@id, @newloginname=@new_ownerto change the owner of my DTS to Domain2\Juls. I ran this while being logged in as Domain2\Juls.Then when I opened the DTS, modified it and saved it, the owner changed back to Domain1\Juls on its own.Why is this happening?Thanks,Juls. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-26 : 16:11:58
|
| Run this in Query Analyzer:SELECT SYSTEM_USERDoes it show Domain2\Juls or Domain1\Juls?Tara |
 |
|
|
Juls
Yak Posting Veteran
51 Posts |
Posted - 2004-04-26 : 16:17:39
|
| Domain2\Juls |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-26 : 16:19:24
|
| Did you verify the owner after you changed the owner? You can view the owner in msdb.dbo.sysdtspackages.Tara |
|
|
|
Juls
Yak Posting Veteran
51 Posts |
Posted - 2004-04-26 : 16:34:25
|
| yes I verified owner. I even looked on all the versions. When updating the owner I update all the available versions of the package. When I go back to make change and resave it, a new version is created with the original owner Domain1\Juls. All previous versions stay as I changed them to Domain2\Juls. |
|
|
|
Kirthika P
Starting Member
1 Post |
Posted - 2008-07-11 : 01:07:53
|
| Hi, Could you please try to change the DTS Ownership to Domain2\Juls being logged in with Domain1\Juls... instead of Domain2\Juls... Please try and revert this.. |
|
|
|
|
|
|
Change owner of DTS