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 |
|
fgilain
Starting Member
5 Posts |
 Posted - 2004-01-21 : 08:34:20
|
| Hi all,1) I'm new to MS SQL Server.2) A user was deleted (in Active Directory) due to the fact that he isn't in the company anymore.This user has created many usefull jobs in DTS and now, when i use the enterpise console, i can always see that many jobs are owned by him.Is there a way to change the owner of a job ? will it create problems if this user continue to be the owner ?thanks for your help.Florent from FRANCE |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-21 : 12:18:20
|
| To change the owner, go into the design mode of the package. Click on Package, then Save As.Tara |
 |
|
|
fgilain
Starting Member
5 Posts |
Posted - 2004-01-23 : 05:34:12
|
| Hi,sorry, but when i do it, i get an error message that says :Package error (title of the message box)Erroe source : Microsoft OLE DB Provider for SQL ServerErros description : DTS Package 'DM_MY_NAME...' alrady exists in that category with a different ID.Florent |
|
|
|
fgilain
Starting Member
5 Posts |
Posted - 2004-01-23 : 05:35:05
|
| oupsss... just read "error" instead of "erros" or "erroe" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-23 : 12:21:56
|
| Then change the name of the package and the owner name so that you don't have duplicates.Tara |
|
|
|
|
|
|
modifying owner of a DTS Job ?