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 |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-10-24 : 12:55:47
|
| is there any way that we can move the DTS packsge and jobs to prod server that should be visible only for that particular database from test server.It should be disabled.It should not available or visible to the existing prod server. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-25 : 00:39:53
|
no you can'tthe dts and jobs are part of the server where they reside, you can however restrict access to them from other users of the server but not from SA for jobs, for dts you can set an owner/user passwordyou can disable them first prior to "movement"quote:
Originally posted by priyaram
is there any way that we can move the DTS packsge and jobs to prod server that should be visible only for that particular database from test server.It should be disabled.It should not available or visible to the existing prod server.
--------------------keeping it simple... |
 |
|
|
|
|
|
DTS & JOBS