How to change DTS package owner?
-
Hi there,
bear with me, I'm not much into DTS yet.
I've created a DTS packages and now I want to change ownership to 'sa'. Because I haven't got the privileges on the network needed for this package.
One of our programmers told me to use this statement to change owner
update msdb..sysdtspackages
set owner = 'new'
where owner = 'old'
;hm....I haven't tried it. Directly updating any system table is not what I consider the best way.
Now, is there another way?
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Well, answered my own question.
For my case the use of the undocumented procedure
sp_reassign_dtspackageowner [@name =] 'name',
[@id =] 'id',
[@newloginname =] 'newloginname'is sufficient.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
-
You beat me by 11 seconds, and basically had the same answer....
Steven
-
quote:
You beat me by 11 seconds, and basically had the same answer....Sorry, and thanks anyway
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
but I used the same source of information as you
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply