I have a user who needs the text SQL commands she put into a job on an old server last year. The job does not have to run, she just needs the many SQL commands she used in every step of the job. Sorry if this is a dumb question but... Can I get this back by restoring the old vintage master database into a new unused SQL server (created just for this).
Thanks Pat. This is in fact SQL server 2000 and you're correct. I've never had to do this before, so I'm not sure exactly what I'm doing yet. Are you saying I'll need to restore MSDB only, and not master ? I'm trying to find some reading on this right now. Thanks again.