The copy database wizard (along with most enterprise manager functions) use sql scripts behind the scenes.  If those jobs didn't get migrated, while others did, it is probably due to...

Another possibility -

You said that the jobs which contain T-SQL were the ones that failed.  If the T-SQL contains any literal quotes (ie. 'dbname') that could throw script generation...

I'm sure someone will come up with a more elegant solution, but, here's one...

create table #orig_table (document char(3))

create table #temp_table (#seq int identity(800,1), #document varchar(6))

insert #orig_table values ('AAA')

insert #orig_table values...

Here's the other method - the one that I chose to use:

1)     Script security and configuration.

2)     Backup master, msdb, and model

3)    

Gary,

Better option would be to change the startup options for the location of the master database files from enterprise manager BEFORE shutting down and moving the files.  Then shut it...

Interesting.  I just did this last weekend.  I had 2 possible ways of accomplishing it.  The first way was similar to what you are trying.  Its a long drawn out...

Hey, Mattie,

At some point, none of us knew ANYTHING about it!

Steve

Randyv,

Just to pose another possible scenario for you...

Set up jobs to do a once a day full backup, and a transaction log backup every 4 hours. (Eliminate the differentials altogether). ...

Umm, if you're not bothering with transaction log backups, then your recovery model should be simple.  In this case there will be no committed transactions in the log to look...

Antares686,

Its not necessary to apply all differential backups, only the most recent.

Joe,

You must apply your full database backup with no recovery first.

Then immediately apply your most recent differential backup.  If...

Steve,

Thank you!  That works!  Still don't understand why xp_dirtree doesn't, but this will get me going again!

Thanks, again!

Steve

yumfin and shew01,

Thanks, but in this particular situation, the drive letters will be changing.  I was pretty comfortable with the move, until I saw that document on how to move...

Fhanlon,

Thank you for your response!  The log situation is exactly what I wanted to hear!  The full text catalogs look like a NIGHTMARE!  I hope SQL 2005 addresses this!

Thanks, again

Steve

I'm sorry.  I glanced through to make sure no "special" procedures were being called, and I missed it.  sp_helprotect doesn't do functions.  I have modified the code so that it DOES...

This one puts the output into SQL commands that you can cut and paste into a new query and execute. 

-- af_revPermissions

-- Verify existence of af_revPermissions procedure.  If it does exist,...