sql server dts: Hey, I just installed sql server 2005 onto a new machine to play around
with it, having used client tools from sql server 2000 on an old machine.
I connect to a remote sql server 2000 database and pretty much all the
functionality is there using management studio - however I am having issues
with bringing up old jobs.

Basically, they are not there to be seen! I can create new jobs and see
them in the list, but old ones won't appear.

Is there a way of accessing these jobs through the management studio,
without reinstalling the old sql server 2000 tools? Can I query some
system tables in the db to find the jobs?

Cheers,

Hello Not,


So in SSMS can you not see jobs on a remote 2K install or on the current
upgraded install?

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

[quoted text, click to view]

Thank you for your reply. I'm connecting to a remote 2k install, and
cannot see any jobs listed (my own or anyone elses) but I can create new
jobs, which appear in the list..

cheers,